IF formula - multiple conditions
Hi,
I am trying to calculate the following using an if formula:
Sales GP% Bonus
50% 90% 2%
60% 95% 3%
How can I use the above data to calculate the Bonus amount in $, when (condition 1) sales are higher than 50% but lower than 60% and (condition 2) GP % is higher than 90% but lower than 95%. Bonus percentage needs to be picked according to these conditions so from the above data, there could be 4 possible combinations for the formula to look at.
Thanks.
Rameen.
|