If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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?
|
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Match then lookup | Tenacity | Worksheet Functions | 10 | December 3rd, 2005 05:30 AM |
Formula Problem - interrupted by #VALUE! in other cells!? | Ted | Worksheet Functions | 17 | November 25th, 2005 05:18 PM |
rounding to nearest hundred dollar in Excel | Diane | New Users | 7 | October 14th, 2005 04:25 PM |
Control breaks in access report? | [email protected] | Setting Up & Running Reports | 1 | September 29th, 2005 05:06 PM |
How do I sum an IIF function in an Access Report? | Ryan G | Setting Up & Running Reports | 20 | August 18th, 2005 06:41 PM |