ExcelBanter - Calculating parts costs rounded to the nearest $15 in Excell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Calculating parts costs rounded to the nearest $15 in Excell (https://www.excelbanter.com/excel-programming/364644-calculating-parts-costs-rounded-nearest-%2415-excell.html)

Mmellex

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?

Tim Williams

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?

All times are GMT +1. The time now is 01:15 AM.