Is there such a function?
 

Hi, I am looking for a formula that will round any amount over a multiple of
$100 to the next $100. So, for example,

Input -- Output

$0 -- $0
$1 -- $100
$50 -- $100
$100 -- $100
$169 -- $200
$200 -- $200
$201 -- $300

etc.

Is there such a formula, and would it involve ROUND, since this is not
really rounding?

Also, can anyone tell me what the syntax of the ROUND formula is?

=ROUND(?,?)

I want to know so I will be able to compute this for myself in the future.

And is there a list of all known Excel formulae?

Thanks!

Julie

Go to Tools--Addins and turn on the Analysis Toolpak (if it's not already).
Then use the MROUND function, thusly:
=MROUND(A1,100)

Hope it helps!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Julie P." wrote in message
...
Hi, I am looking for a formula that will round any amount over a multiple
of
$100 to the next $100. So, for example,

Input -- Output

$0 -- $0
$1 -- $100
$50 -- $100
$100 -- $100
$169 -- $200
$200 -- $200
$201 -- $300

etc.

Is there such a formula, and would it involve ROUND, since this is not
really rounding?

Also, can anyone tell me what the syntax of the ROUND formula is?

=ROUND(?,?)

I want to know so I will be able to compute this for myself in the future.

And is there a list of all known Excel formulae?

Thanks!

Julie

"Anne Troy" wrote in message
news:357e3$42b745a9$466eb880$24595@allthenewsgroup s.com...
Go to Tools--Addins and turn on the Analysis Toolpak (if it's not
already).
Then use the MROUND function, thusly:
=MROUND(A1,100)

Hope it helps!


Thanks Anne! But when I do this, I get an error:

"#NAME?"

Did I do something wrong?

You MUST use the Analysis toolpak. Did you turn it "on"?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Julie P." wrote in message
...
"Anne Troy" wrote in message
news:357e3$42b745a9$466eb880$24595@allthenewsgroup s.com...
Go to Tools--Addins and turn on the Analysis Toolpak (if it's not
already).
Then use the MROUND function, thusly:
=MROUND(A1,100)

Hope it helps!


Thanks Anne! But when I do this, I get an error:

"#NAME?"

Did I do something wrong?

"Anne Troy" wrote in message
news:51f8$42b747dc$466eb880$24864@allthenewsgroups .com...
You MUST use the Analysis toolpak. Did you turn it "on"?


Yes, I did, as well as the VBA one. Then I redid the formula, and got the
error.

=CEILING(A1,100)

Julie P. wrote:

Hi, I am looking for a formula that will round any amount over a multiple of
$100 to the next $100. So, for example,

Input -- Output

$0 -- $0
$1 -- $100
$50 -- $100
$100 -- $100
$169 -- $200
$200 -- $200
$201 -- $300

etc.

Is there such a formula, and would it involve ROUND, since this is not
really rounding?

Also, can anyone tell me what the syntax of the ROUND formula is?

=ROUND(?,?)

I want to know so I will be able to compute this for myself in the future.

And is there a list of all known Excel formulae?

Thanks!

Julie

"garfield-n-odie" wrote in message
...
=CEILING(A1,100)



Thanks so much Garfield! It worked!

=ROUNDUP(A20,-2)

or

=CEILING(A1,100)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Julie P." wrote in message
...
Hi, I am looking for a formula that will round any amount over a multiple
of
$100 to the next $100. So, for example,

Input -- Output

$0 -- $0
$1 -- $100
$50 -- $100
$100 -- $100
$169 -- $200
$200 -- $200
$201 -- $300

etc.

Is there such a formula, and would it involve ROUND, since this is not
really rounding?

Also, can anyone tell me what the syntax of the ROUND formula is?

=ROUND(?,?)

I want to know so I will be able to compute this for myself in the future.

And is there a list of all known Excel formulae?

Thanks!

Julie