View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default 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?