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?
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?
15* (round(x/15,0))
Tim
"Mmellex" <Mmellex@discussions.microsoft.com> wrote in message news:ED7C325D-6AC5-43E8-BD7A-2DFB943D7A66@microsoft.com...
> 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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks