| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating parts costs rounded to the nearest $15 in Excell
Would like to set up worksheet calcualting parts costs rounded to the nearest
$15 for a 'labor surcharge' but I can't figure out how to take the 15% and get Excel to round this cost to the nearest $15. Can this be done? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating parts costs rounded to the nearest $15 in Excell
15* (round(x/15,0))
Tim "Mmellex" wrote in message ... Would like to set up worksheet calcualting parts costs rounded to the nearest $15 for a 'labor surcharge' but I can't figure out how to take the 15% and get Excel to round this cost to the nearest $15. Can this be done? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| show fractions rounded up to nearest 1/16th inch | Excel Discussion (Misc queries) | |||
| Average rounded to nearest 0.50 | Excel Discussion (Misc queries) | |||
| Allocated amount rounded to nearest .25 without exceeding total | Excel Worksheet Functions | |||
| Calculating costs | Excel Worksheet Functions | |||
| Ensuring input is rounded up to nearest 10 | Excel Discussion (Misc queries) | |||
Linear Mode
