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
 Dividing and Rounding
 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):
Relevant Pages
