excel 2007 formula

G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top