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
|
