Formula

[keao46]

I am trying to build a formula that will take the product of two values plus the product of two other values minus a maximum amount. If result of that equation is greater than $5000 then I want the value to be no more than $5000. If it is less than $5000 then I want the value to be what it is

[#2 · Accepted solution]

@keao46 

What do you mean by "minus a maximum amount"?

To limit the result to a maximum of 5000, use

=MIN(value1*value2+value3*value4, 5000)

[#3]

That was easy. Thank you