View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
STEVE THE PARTS GUY STEVE THE PARTS GUY is offline
external usenet poster
 
Posts: 3
Default excel 2007 formula

I need a formula to calculate a Labor dollar amount based on a labor rate of
$95.00 per hour and a shop supply charge equal to 10% of the labor dollar
amount with a minimum shop supply charge of $2.95 and a maximum of $24.95.
Example:
$95.00 x .02 Hours = $19.00.

$19.00 x 10% = $1.90 (does not meet minimum of $2.95)

$19.00 + $2.95 = $21.95 (final result)