You need a little IF/THEN assistance:

=IF(Sheet4!BY60, CEILING(Sheet4!BY6,25), FLOOR(ABS(Sheet4!BY6),25)*-1)
--
"Actually, I *am* a rocket scientist." -- JB

Your feedback is appreciated, click YES if this post helped you.


"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