if statement formula
 

I want to create a cell that takes a total, and multplies it by 15%, however,
if the 15% is less than twenty, I want the amount to be 20.

I.E.-- subtotal is $95.00, so 15% would be $14.25. However I want the cell
to show$20.00.
I.E.-- sutotal is $300.00, so 15% would be $45.00. I want the cell to show
the $45.00.

Thank you

If your total is in cell A1 then in B1 type =IF(A1*0.15<20,20,A1*0.15)

Regards
Rowan

"Marlis" wrote:

I want to create a cell that takes a total, and multplies it by 15%, however,
if the 15% is less than twenty, I want the amount to be 20.

I.E.-- subtotal is $95.00, so 15% would be $14.25. However I want the cell
to show$20.00.
I.E.-- sutotal is $300.00, so 15% would be $45.00. I want the cell to show
the $45.00.

Thank you

Marlis,

=MAX(Total*15%, 20)
=MAX(SUM(A2:A9)*15%, 20)
--
Earl Kiosterud
www.smokeylake.com

"Marlis" wrote in message
...
I want to create a cell that takes a total, and multplies it by 15%,
however,
if the 15% is less than twenty, I want the amount to be 20.

I.E.-- subtotal is $95.00, so 15% would be $14.25. However I want the
cell
to show$20.00.
I.E.-- sutotal is $300.00, so 15% would be $45.00. I want the cell to
show
the $45.00.

Thank you