| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula needed that rounds to 99 cents
I have costs in column A, that I want to mark up and multiply by a factor of
2 or 3 in varying cases. However I want to the result to end with .99 cents as opposed to whatever change it will be i.e. A B C costs price formula desired price 16.50 =3*A3 49.99 13.50 =3*A4 40.99 Any ideas, I thought something along the lines fo the ceiling function would work, but I am not certain. Any help is appreciated thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel rounds data when I open .csv files | Setting up and Configuration of Excel | |||
| formula rounds differently in 2 spreadsheets | Excel Worksheet Functions | |||
| I need a %age increase formula that rounds up to the nearest $10 | Excel Worksheet Functions | |||
| Round function that rounds down if 5 | Excel Worksheet Functions | |||
| How can set how a number rounds up in excel | Excel Worksheet Functions | |||
Threaded Mode
