# Re: Dividing and Rounding

*From*: "Anne Troy" <ng@xxxxxxxxxxxxxxxxxx>*Date*: Wed, 9 Nov 2005 11:58:40 -0500

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

>

.

**References**:**Dividing and Rounding***From:*puppypants

- Prev by Date:
**Dividing and Rounding** - Next by Date:
**Linking two spreadsheets** - Previous by thread:
**Dividing and Rounding** - Next by thread:
**Re: Dividing and Rounding** - Index(es):