Dividing and Rounding

[puppypants]

HELP!! I'm still kinda new to Excel and all the wonders of formulas...
need to create a formula that will take the dollar value of one cell
divide it by 1.0577, and then round the result to the next .05 cents
Any assitance would be greatly appreciated

 

[Anne Troy]

I know there's another way and Bob or Dave will provide it, I'm sure, but I
can't remember it. I like to use MROUND, but you must have the Analysis
Toolpak (Tools-->Addins...) checked. Try this:
=MROUND(A1/1.0577,0.05)
************
Anne Troy
www.OfficeArticles.com

 

[bpeltzer]

If your dollar value is in A1, =ROUND(20*A1/1.0577,0)/20.
I took 'round' litterally; if you want to always round UP then:
=CEILING(A1/1.0577,0.05)

 

[puppypants]

Thanks to both of you - you saved the day!

 

[puppypants]

I have a second question - if I need to round either up or down
depending on how the original dollar value divides, is there anothe
formula for this? I tried both th emround and round, and it seems as i
it always rounds up to the next .05. Thanks

 

[Peo Sjoblom]

If you use the formulas provided it will use 0.5 since that is what you
asked for, if you want to round to the nearest cent use

=ROUND(value,2)

 

[joeu2004]

I have a second question - if I need to round either up or down,
depending on how the original dollar value divides, is there another
formula for this? I tried both th emround and round, and it seems as if
it always rounds up to the next .05.

MROUND() seems to round to the "nearest" 0.05 in my version
of Excel (2003). MROUND(1.0249,0.05) yields 1, whereas
MROUND(1.025,0.05) yields 1.05. If that is not what you are
talking about, please give a concrete example with both the
current result and your preferred result.