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" wrote
in message ...

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