Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need formula to round number up to always end in X.X9
I have a spreadsheet with prices. If the price is 2.55, I want the formula
to round it up to 2.59. If it is 3.01, I want the formula to round it to 3.09. The last digit always needs to be a 9, and it always needs to round UP to the next .x9. Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to round off number to .95 cents | Excel Worksheet Functions | |||
can you round a number then use it in another formula | Excel Discussion (Misc queries) | |||
Is there a formula to round a number to the nearest .09? | Excel Worksheet Functions | |||
formula to round up any number less than 35 upto 35. | Excel Discussion (Misc queries) | |||
i would like to know a formula on how to round a number to 500 | Excel Discussion (Misc queries) |