Round up to nearest 25 or 50?

  • Thread starter Thread starter Ed from AZ
  • Start date Start date
E

Ed from AZ

(Using XL 2000) I read the help on ROUND and ROUNDUP, but everything
I tried only allowed me to round up to the nearest whole number.

Is there a way I can round $265 to the nearest 25 or 50 increment - to
$275 or $300??

Ed
 
Thanks, Ron!! I had looked at CEILING, too, but for some reason
couldn't make it work?!!? But now it works great!

Must just be Excel messing with my
Ed
 
(Using XL 2000)  I read the help on ROUND and ROUNDUP, but everything
I tried only allowed me to round up to the nearest whole number.

Is there a way I can round $265 to the nearest 25 or 50 increment - to
$275 or $300??

Ed
Click to expand...

Another Method:-

=FLOOR(A1,25)+25
=FLOOR(A1,25)+50
 
Got another wrinkle I hadn't expected. The workbook is synced with my
WIndows Mobile device. Excel mobile only has ROUND - it does not have
ROUNDUP, MROUND, CEILING, or FLOOR.

ROUND works for rounding up, as long as the number is closer to the
upper number than it is the lower number. Otherwise it will round
down, and that totally defeats the purpose.

Is there a way to force ROUND to only look up?

Ed
 
Hi Ed

Then maybe for the mobile to work as well
=(INT(A1/25)+1)*25

--

Regards
Roger Govier

Ed from AZ said:
Got another wrinkle I hadn't expected. The workbook is synced with my
WIndows Mobile device. Excel mobile only has ROUND - it does not have
ROUNDUP, MROUND, CEILING, or FLOOR.

ROUND works for rounding up, as long as the number is closer to the
upper number than it is the lower number. Otherwise it will round
down, and that totally defeats the purpose.

Is there a way to force ROUND to only look up?

Ed

__________ Information from ESET Smart Security, version of virus
signature database 5223 (20100623) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 5223 (20100623) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
Well picked up Ron!

--

Regards
Roger Govier

Ron Rosenfeld said:
Gives what I believe is not desired answer when exactly at a divisible
by 25 value. eg:

300-->325

I believe the OP probably wants 300-->300 and 301-->325


__________ Information from ESET Smart Security, version of virus
signature database 5226 (20100624) __________

The message was checked by ESET Smart Security.

http://www.eset.com
Click to expand...

__________ Information from ESET Smart Security, version of virus signature database 5226 (20100624) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
I came up with
=IF((ROUND(A1/25,0)*25)<A1,ROUND((A1+20)/25,0)*25,ROUND(A1/25,0)*25)

Seems to do it.

Gonna be a bear when I have to insert another formula in place of my
testing "A1".
But that's Excel for ya!

Thanks for all the assistance!
Ed
 
(Using XL 2000) I read the help on ROUND and ROUNDUP, but everything
I tried only allowed me to round up to the nearest whole number.

Is there a way I can round $265 to the nearest 25 or 50 increment - to
$275 or $300??

Ed
Click to expand...

A little easier:

roundup(A1/25,0)*25

I can't take the credit though
 
Is there a way I can round $265 to the nearest 25 or 50 increment - to
$275 or $300??

Ed
Click to expand...

The function "CEILING.MATH" with the "significance" 25 0r 50 would do the job.
Cheers
Audie Bencosme
 
Back
Top