Rounding to the nearest 25 including negative numbers??
=MROUND(A1,IF(A1<0,-25,25))
"Bob" wrote:
I have the following formula
=CEILING(Sheet4!BY6, 25)
How I get it to round negative numbers too
It works with positive numbers but when I insert ie -360, it should read
-350 but I get the following #NUM!
--
Bob
|