| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rounding Up For Retail Pricing
Could someone please help me with the formula to always round up To 5's and
9's in the hundredths digit. For example if the amount is $3.20- $3.25 it would round to $3.25. If the the number is $3.26 - $3.29, it would round up to $3.29. I am using the following formula already to calculate pricing from cost in Excel 2003 and currency formulations. =(I3/9)/.54+1.12 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| rounding a number created by a formula to a retail price | Excel Worksheet Functions | |||
| Retail pricing to the $x.x9 or $x.x5 | Excel Discussion (Misc queries) | |||
| Retail Pricing | Excel Discussion (Misc queries) | |||
| Retail Price rounding help needed | Excel Worksheet Functions | |||
| Rounding - for retail prices | Excel Worksheet Functions | |||
Threaded Mode
