calculating a minimum fee
 

I'm looking for a formula that will calculate the following information:

If 15% of the sum of a range of cells is less than $40.00 then the fee is
$40.00.
If 15% of the sum of a range of cells is $40.00 or higher, then the fee is
15%.

I hope that made sense.

In other words, the fee is 15% or $40, whichever is higher.

calculating a minimum fee
 

Hi

Look at this:

=MAX(A1*0.15,40)

Regards,
Per

"Jackie" skrev i meddelelsen
...
I'm looking for a formula that will calculate the following information:

If 15% of the sum of a range of cells is less than $40.00 then the fee is
$40.00.
If 15% of the sum of a range of cells is $40.00 or higher, then the fee is
15%.

I hope that made sense.

In other words, the fee is 15% or $40, whichever is higher.

calculating a minimum fee
 

=MAX(40,15%*SUM(A1:A9))

Adjust the range (A1:A9) to your needs

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jackie" wrote in message
...
I'm looking for a formula that will calculate the following information:

If 15% of the sum of a range of cells is less than $40.00 then the fee is
$40.00.
If 15% of the sum of a range of cells is $40.00 or higher, then the fee is
15%.

I hope that made sense.

In other words, the fee is 15% or $40, whichever is higher.

calculating a minimum fee
 

YOU ARE FABULOUS! THANK YOU SO MUCH.



"Niek Otten" wrote:

=MAX(40,15%*SUM(A1:A9))

Adjust the range (A1:A9) to your needs

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jackie" wrote in message
...
I'm looking for a formula that will calculate the following information:

If 15% of the sum of a range of cells is less than $40.00 then the fee is
$40.00.
If 15% of the sum of a range of cells is $40.00 or higher, then the fee is
15%.

I hope that made sense.

In other words, the fee is 15% or $40, whichever is higher.