Rounding to the nearest 25 including negative numbers??

  • Thread starter Thread starter Bob
  • Start date Start date
B

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!
 
You need a little IF/THEN assistance:

=IF(Sheet4!BY6>0, CEILING(Sheet4!BY6,25), FLOOR(ABS(Sheet4!BY6),25)*-1)
 
By the way, your thread title says "nearest 25" but you're example used
CEILING, which always rounds UP. So my first answer was in the same vein.

But if you really want the numbers to round to the nearest 25, both up or
down, then use this:

=IF(G3>0,MROUND(G3,25),MROUND(ABS(G3),25)*-1)
 
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!
Click to expand...

=round(sheet4!BY6/25,0)*25
--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding up or down to nearest whole number 1
Round to nearest multiple 3
Round number to whole No 25 1
How can I Round up to the nearest .25 11
rounding up to nearest specified whole number 1
Average rounded to nearest 0.50 4
Rounding 2
Rounding to nearest number 2

Back
Top