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)

excel 2007 formula
 

try:

=A1*B1+MIN(MAX(A1*B1*0.1,2.95),24.95)

A1=Rate
B1=Hours

HTH

"STEVE THE PARTS GUY" wrote:

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)