| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rounding Up to a specific number
In article , "Ron Coderre" wrote:
With A1: (a currency amount) Try this: B1: =CEILING(A1+0.01,1)-0.01 Does that help? Regards, Ron Microsoft MVP (Excel) "Phil" wrote in message ... I want to round a price up to the nearest $.99. So if a number is $4.13 I want it to round it up to $4.99, if its $10.53 Iwant to round it up to $10.99. How do I do this? Ah ... the obvious answer is 'get a marketing degree' :) That's one of their favourite tricks ... trying to hide $5 as $4-99 and so on. :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding up to a set of specific numbers? | Excel Worksheet Functions | |||
| Rounding to a specific value (up or down) | Excel Worksheet Functions | |||
| rounding to a specific number | Excel Worksheet Functions | |||
| specific rounding of formulas which may need to include an IF stat | Excel Worksheet Functions | |||
| Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions | |||
Threaded Mode
