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.