Dividing and Rounding

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!

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" <[email protected]> wrote
in message news:[email protected]...
>
> 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...o&userid=28654
> View this thread: http://www.excelforum.com/showthread...hreadid=483554
>

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)

"puppypants" wrote:

>
> 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...o&userid=28654
> View this thread: http://www.excelforum.com/showthread...hreadid=483554
>
>

Thanks to both of you - you saved the day!

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. 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)


--

Regards,

Peo Sjoblom

"puppypants" <[email protected]> wrote
in message news:[email protected]...
>
> 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. Thanks!
>
>
> --
> puppypants
> ------------------------------------------------------------------------
> puppypants's Profile:
http://www.excelforum.com/member.php...o&userid=28654
> View this thread: http://www.excelforum.com/showthread...hreadid=483554
>

puppypants wrote:
> 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.

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.