Rounddown

[srizki]

How can I ROUNDDOWN a number to nearest 50, so for example my numbers are 82.3 or 96.7 I want to round down to 50 in each case, or if the numbers are 336.6, 244, 298.2, I want 300, 200 and 250 respectively.

Thanks

 

[JimM]

How about

=FLOOR(A1,50)

 

[VoG]

Try

=FLOOR(A1,50)

 

[srizki]

Thanks Jim, I forgot to use it,

Thanks again.