G
Guest
What is the formula for rounding a dollar amount to the nearest nickel?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-)
1.20 or 1.23 = 1.25. ;-)
G
Guest
Try this:
For a value in A1
B1: =ROUND(A1/0.05,0)*0.05
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
For a value in A1
B1: =ROUND(A1/0.05,0)*0.05
Does that help?
***********
Regards,
Ron
XL2002, WinXP-Pro
G
Guest
Ya know what? Between reading some posts, and installing something called an
Analysis Toolpak, it worked out! Should have delved in a little deeper
before asking. Thank you, though!!
Analysis Toolpak, it worked out! Should have delved in a little deeper
before asking. Thank you, though!!
C
Chip Pearson
The Analysis Tool Pak (ATP) in an add-in that provides dozens of
addition functions. If you have the ATP loaded (go to the Tools
menu, choose Add-Ins, and put a check next to Analysis Tool Pak),
you can use the MROUND function to round to the nearest nickel.
=MROUND(A1,0.05)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
addition functions. If you have the ATP loaded (go to the Tools
menu, choose Add-Ins, and put a check next to Analysis Tool Pak),
you can use the MROUND function to round to the nearest nickel.
=MROUND(A1,0.05)
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
G
Guest
That's exactly what I did... as you descibed below. Works great!!