if calc doesn't meet min, auto insert flat fee

[channyne]

Hello and thanks in advance for any help.

I'm trying to create a purchase sheet that includes a set up fee. The fee is either a percentage of the total or a flat fee of $130 whichever is greater.

I have the formula calculating the percentage based on the subtotal [=15% * C1] but I want to know if I can take it a step further and make it so if it doesn't hit that min it auto inputs the flat fee of $130.

Appreciate any help!

 

[Fluff]

How about
=MAX(130,C1*15%)

 

[channyne]

How about
=MAX(130,C1*15%)

That worked! Thank you!!

 

[Fluff]

You're welcome & thanks for the feedback