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.