Rounding to the nearest 25 including negative numbers??
Refer help on CEILING
It is supposed to return number rounded up, away from zero.
=CEILING(-2.5, 2)
Returns an error, because -2.5 and 2 have different signs (#NUM!)
You should be using
=CEILING(Sheet4!BY6, -25)
If this post helps click Yes
---------------
Jacob Skaria
"Jacob Skaria" wrote:
=IF(Sheet4!BY6<0,-CEILING(ABS(Sheet4!BY6),25),CEILING(Sheet4!BY6,25) )
There may be a different solution
If this post helps click Yes
---------------
Jacob Skaria
"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
|