Putting in a minimum amount in a cell

I have a row that is a percent of sales with this:

=(F4*0.2+G4*0.1)*I4

"I4 will either be 1.0 or 0.5"

Now I want to have it so if this equation equals less than 100 with I4 being 1.0 to equal 100 OR if I4 is .5 then it should be 50

I have looked all around and I am no excel wizard so this is troubling me significantly.


Any help would be appreciated in advance!

Welcome to the forum.

Please take a few minutes to read the forum rules, and then amend your thread title accordingly.

Thanks.

It's better, thank you.

Try =I4 * MAX(100, F4/5 + G4/10)

Man that works!


Thank you sooooo much!