Hi, I want to create a sum formula, but to round DOWN to nearest 5 e.g.



Cell B4 = 125.90
Cell C4 = 213.20

The formula =sum(C4:B4) would give a result of 339.1

I want to add a round function, so that the result will be rounded down to the nearest 5 (or multiple of) i.e. 335.0

Tommy

In case you really want rounddown, then

Try
But what happens if the sum is already a multiple of 5?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks guys.

FLOOR works for me

Tommy

You're welcome. Adding some rep would be nice too...

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post