Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Let me try this again since I did a poor job explaining the first post.
I am working on a price list. I am allowed to round up to the next nickel if the price is not on the nickel. So if the price is $1.60 or $1.65 it is ok. But if the price is showing on the list at $1.61, I am allowed to round that to $1.65. The formula I am using is =ROUND(A1/0.05,0)*0.05 and it works for everything that is not on the nickel. For those prices on the nickel, the formula is rounding up to the next nickel. Meaning that $1.60 is rounding to $1.65. What adjustment do I need to make to the formula? thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I correct rounding errors in Excel formulas? | Excel Worksheet Functions | |||
Problems: rounding & formatting Text/# combinations | Excel Discussion (Misc queries) | |||
Rounding to the Nearest Eighth | Excel Discussion (Misc queries) | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
Banker's Rounding - need help! | Excel Discussion (Misc queries) |