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 value to be no more than $5000. If it is less than $5000 then I want the value to be what it is
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)
2 Replies
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
