How to use IF Condition for Incentive Calculations
According to the sales, we have to give incentive here
We have a data showing sales and incentives.
IF Condition Uses
This is our condition which we have shown in the picture
2. If someone made 35 sales then 35*20
3. If someone did 45 then 40*20 plus 5*60
4. If someone did 85 then 40*20 plus 40*60 plus 5*80
5. If someone did 120 then 40*20 plus 40*60 plus 20*80 plus 20*100
How to use IF Formula
So first we will apply the simple formula and then edit it later, we will apply the complete formula in two times.
If A2 is less than or equal to 40 then 20, if A2 is less than or equal to 80 then 60,
If A2 is smaller than or equal to 100 then 80, if A2 is greater than 100 then 100
=IF(A2<=40,20,IF(A2<=80,60,IF(A2<=100,80,IF(A2>100,100)))))
We will edit the red part by following this step as shown in the picture.
A2 Cell:-
=IF(A2<=40,A2*20,IF(A2<=80,(40*20)+((A2-40)*60),IF(A2<=100,(40*20)+(40*60)+((A2-80)*80),IF(A2>100,(40*20)+(40*60)+(20*80)+((A2-100)*100)))))
Here we got our right answer.
Conclusion:-
In this way, we can get incentives by using the condition, the formula of IF is very important, it is important for us to know its correct use.
No comments:
Post a Comment