Thread: Rounding a number down to the nearest 5?
View Single Post
  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default
My pleasure, thanks for the thanks

Regards,

Peo Sjoblom

"maluli" wrote:

That works perfectly. Thanks for you input Peo!!

"Peo Sjoblom" wrote:

One way

=FLOOR(A1,5)


Regards,

Peo Sjoblom

"maluli" wrote:

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.
Reply With QuoteReply With Quote