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

[Ron Rosenfeld]

e.g.

Roundup:

=ceiling(a1,25)
=ROUNDUP(A1/25,0)*25

Round
=round(a1/25,0)*25
=MROUND(A1,25)

[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

On Jun 22, 11:36 am, Ron Rosenfeld <r...@nospam.net> wrote:
> On Tue, 22 Jun 2010 10:45:55 -0700 (PDT), Ed from AZ
>

[Ron Rosenfeld]

On Tue, 22 Jun 2010 12:12:00 -0700 (PDT), Ed from AZ
<prof_...@yahoo.com> wrote:

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

Glad to help. Thanks for the feedback.

>
>Must just be Excel messing with my

Yeah. It'll do that sometimes :-)

>Ed
>
>
>

[Ms-Xl-Learner]

Another Method:-

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

-----------------------
Ms-Exl-Learner
-----------------------

[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

"Ed from AZ" <prof_...@yahoo.com> wrote in message
news:3f0fc5b6-0a3f-445b...@g19g2000yqc.googlegroups.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
>
>
>

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

The message was checked by ESET Smart Security.

http://www.eset.com

[Ron Rosenfeld]

Try:

=(INT((A1-1)/25)+1)*25

or for 50's

=(INT((A1-1)/50)+1)*50

[Ron Rosenfeld]

On Wed, 23 Jun 2010 22:53:06 +0100, "Roger Govier"
<ro...@technology4nospamu.co.uk> wrote:

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

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

[Roger Govier]

Well picked up Ron!

--

Regards
Roger Govier

"Ron Rosenfeld" <r...@nospam.net> wrote in message
news:6v4526tdvpqgg2gki...@4ax.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
>
>
>

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

[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

[Ron Rosenfeld]

As I wrote, I think

=(INT((A1-1)/25)+1)*25

will work also. And it is shorter, and uses fewer function calls.

[jafft...@gmail.com]

A little easier:

roundup(A1/25,0)*25

I can't take the credit though

[benc...@gmail.com]

> 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