Dividing and Rounding

  • Thread starter Thread starter puppypants
  • Start date Start date
P

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
 
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
 
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)
 
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
 
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)
 
puppypants said:
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.
Click to expand...

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.
 
Back
Top