Forum Discussion
Solved
Multiply formula with multiple criteria
I need a formula that allows me to calculate commission based off of several scenarios. If they have less than 3 deals (let's say in cell A1 to make simple) than I need to multiply their revenue (in ...
=A2*IF(A1<=3, 0.75, LOOKUP(A2, {0, 75000, 100000}, {0.80, 0.85, 0.90}))
=A2*IF(A1<=3, 0.75, LOOKUP(A2, {0, 75000, 100000}, {0.80, 0.85, 0.90}))
AMAZING!!! Thank you so much! That was driving me crazy!