Round up to nearest 25 or 50?

[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

 

[Ed from AZ]

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

 

[Ms-Xl-Learner]

(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

Another Method:-

=FLOOR(A1,25)+25
=FLOOR(A1,25)+50

 

[Ed from AZ]

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

 

[Roger Govier]

Hi Ed

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

--

Regards
Roger Govier

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

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

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Roger Govier]

Well picked up Ron!

--

Regards
Roger Govier

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

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

The message was checked by ESET Smart Security.

http://www.eset.com

 

[Ed from AZ]

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

 

[jafftownusa]

(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

A little easier:

roundup(A1/25,0)*25

I can't take the credit though

 

[bencosmea]

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

Ed

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