What is the formula for rounding a dollar amount to the nearest ni
What is the formula for rounding a dollar amount to the nearest nickel?
|
What is the formula for rounding a dollar amount to the nearest ni
Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 =
1.20 or 1.23 = 1.25. ;-) "JeriSys" wrote: What is the formula for rounding a dollar amount to the nearest nickel? |
What is the formula for rounding a dollar amount to the neares
Try this:
For a value in A1 B1: =ROUND(A1/0.05,0)*0.05 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JeriSys" wrote: Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 = 1.20 or 1.23 = 1.25. ;-) "JeriSys" wrote: What is the formula for rounding a dollar amount to the nearest nickel? |
What is the formula for rounding a dollar amount to the neares
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!! "Ron Coderre" wrote: Try this: For a value in A1 B1: =ROUND(A1/0.05,0)*0.05 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JeriSys" wrote: Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 = 1.20 or 1.23 = 1.25. ;-) "JeriSys" wrote: What is the formula for rounding a dollar amount to the nearest nickel? |
What is the formula for rounding a dollar amount to the neares
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 "JeriSys" wrote in message ... 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!! "Ron Coderre" wrote: Try this: For a value in A1 B1: =ROUND(A1/0.05,0)*0.05 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JeriSys" wrote: Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 = 1.20 or 1.23 = 1.25. ;-) "JeriSys" wrote: What is the formula for rounding a dollar amount to the nearest nickel? |
What is the formula for rounding a dollar amount to the neares
That's exactly what I did... as you descibed below. Works great!!
"Chip Pearson" wrote: 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 "JeriSys" wrote in message ... 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!! "Ron Coderre" wrote: Try this: For a value in A1 B1: =ROUND(A1/0.05,0)*0.05 Does that help? *********** Regards, Ron XL2002, WinXP-Pro "JeriSys" wrote: Didn't make sense... I meant cents rounding to nearest nickle,Example: 1.22 = 1.20 or 1.23 = 1.25. ;-) "JeriSys" wrote: What is the formula for rounding a dollar amount to the nearest nickel? |
All times are GMT +1. The time now is 01:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com