Round Down Sum Formula
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
|