#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Into your table with data, add a column (may be hidden) , where depending on sales and GP % the bonus group number (values 1, 2, 3 or 4) for every row is calculated.
The bonus will be calculated as Code:
=CHOOSE(BonusGroupNumber, Bonus1, Bonus2, Bonus3, Bonus4) |
Tags |
if formula |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with formula with more conditions | allex011 | Excel | 1 | 10-29-2018 03:22 AM |
Formula to make sum based on multiple conditions, HELP! | ilsel | Excel | 3 | 11-15-2017 02:03 AM |
Excel Formula for Multiple Conditions & Results | nowco | Excel | 4 | 03-16-2016 11:24 AM |
Multiple If Conditions | z941714 | Excel | 8 | 08-09-2015 04:12 PM |
6 conditions formula | paconovellino | Excel | 2 | 03-05-2012 06:45 AM |