Forum Discussion
Solved
Formula
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 v...
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)
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)
That was easy. Thank you