Rounding a number down to the nearest 5?

maluli · Jan 14, 2005

I want to be able to have numbers in excel round down to nearest 5. Example
296 down to 295 or 294 down to 290.

Peo Sjoblom · Jan 14, 2005

One way

=FLOOR(A1,5)

Regards,

Peo Sjoblom

maluli · Jan 14, 2005

That works perfectly. Thanks for you input Peo!!

Peo Sjoblom said:
One way

=FLOOR(A1,5)

Regards,

Peo Sjoblom

Peo Sjoblom · Jan 14, 2005

My pleasure, thanks for the thanks

Regards,

Peo Sjoblom