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" <Marlis@discussions.microsoft.com> wrote in message
news:E5EB9451-DBAF-4406-89E3-13F2039F117E@microsoft.com...
>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