Re: Dividing and Rounding



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

"puppypants" <puppypants.1y8nkz_1131554746.9633@xxxxxxxxxxxxxxxxxxxxx> wrote
in message news:puppypants.1y8nkz_1131554746.9633@xxxxxxxxxxxxxxxxxxxxxxxx
>
> HELP!! I'm still kinda new to Excel and all the wonders of formulas...I
> 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!
>
>
> --
> puppypants
> ------------------------------------------------------------------------
> puppypants's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=28654
> View this thread: http://www.excelforum.com/showthread.php?threadid=483554
>


.