Rounding to the nearest 25 including negative numbers??

[Bob]

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!

 

[Jacob Skaria]

=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

 

[Teethless mama]

=MROUND(A1,IF(A1<0,-25,25))

 

[Bob]

Fantastic it works
Many thanks

--
Bob

=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]

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

 

[Teethless mama]

another...

=MROUND(A1,SIGN(A1)*25)