Incentive Calculation with few Condition
Solved/Closed
YeohSeow
Posts
17
Registration date
Sunday May 2, 2010
Status
Member
Last seen
May 25, 2010
-
May 2, 2010 at 03:44 AM
YeohSeow Posts 17 Registration date Sunday May 2, 2010 Status Member Last seen May 25, 2010 - May 3, 2010 at 06:50 AM
YeohSeow Posts 17 Registration date Sunday May 2, 2010 Status Member Last seen May 25, 2010 - May 3, 2010 at 06:50 AM
Related:
- How to calculate incentive percentage in excel
- How to calculate 90 days from date in excel - Guide
- How to take screenshot in excel - Guide
- Number to words in excel - Guide
- How to calculate fuel surcharge - Excel Forum
- How to change author in excel - Guide
2 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 2, 2010 at 10:40 AM
May 2, 2010 at 10:40 AM
This is the best I could make out
1. at least one value in column A, B, C and D needs to be >= 2
2. at least one value in column E, F, G, H, and I needs to be >= 2
3. If both above conditions (1 and 2) are true and:
a. value in K is between 8-11, then incentive is 1000
b. value in K is greater or equal to 12, then incentive is 1500
if condition 1, 2 or 3 is not true then incentive is 0
If that is correct then use this formula (this is for row 7)
=IF(AND(OR(A7>=2, B7>=2,C7>=2,D7>=2), OR(E7>=2,F7>=2, G7>=2,H7>=2,I7>=2)),IF(AND(K7>=8,K7<=11),1000,IF(K7>=12,1500,0)),0)
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 2, 2010 at 07:18 AM
May 2, 2010 at 07:18 AM
It seems that you need to use IF statements. Unfortunately I am not able to understand your conditions etc. But the basic idea would be
=IF(AND(OR(A1="model a",A1="model b",A1="model c",A1="model d"),B1<2),59, IF(AND(OR(A1="model e",A1="model f",A1="model g",A1="model h",A1="model i"),B1<2), 60, IF( AND(C1>=8, C1<=11), 1000, IF(C1>12, 1500,0) )))
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
=IF(AND(OR(A1="model a",A1="model b",A1="model c",A1="model d"),B1<2),59, IF(AND(OR(A1="model e",A1="model f",A1="model g",A1="model h",A1="model i"),B1<2), 60, IF( AND(C1>=8, C1<=11), 1000, IF(C1>12, 1500,0) )))
Could you please upload a sample file with sample data etc on some shared site like https://authentification.site and post back here the link to allow better understanding of how it is now and how you foresee.
YeohSeow
Posts
17
Registration date
Sunday May 2, 2010
Status
Member
Last seen
May 25, 2010
May 2, 2010 at 09:49 AM
May 2, 2010 at 09:49 AM
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
May 2, 2010 at 10:03 AM
May 2, 2010 at 10:03 AM
Now based on the data could you explain what you are looking for. I am still lost at your conditions. Incentive can occur based on any of the three, or all three has to be true etc. If you could show by example what you seek, it would help in understanding your issue
YeohSeow
Posts
17
Registration date
Sunday May 2, 2010
Status
Member
Last seen
May 25, 2010
May 2, 2010 at 10:39 AM
May 2, 2010 at 10:39 AM
Dear Friend,
Latest link as below https://authentification.site/files/22232669/Sample_1.xls
Condition 1: must archieve minimum 2 units
Condition 2: must archieve minimum 2 units
Condition 3: Total Units with minimum 8 to 11 units entitle for 1000 & above 12 units 1500
More detail kindly refer to the file.
Latest link as below https://authentification.site/files/22232669/Sample_1.xls
Condition 1: must archieve minimum 2 units
Condition 2: must archieve minimum 2 units
Condition 3: Total Units with minimum 8 to 11 units entitle for 1000 & above 12 units 1500
More detail kindly refer to the file.
May 2, 2010 at 10:51 AM
i just updated the file, here the link :https://authentification.site/files/22232906/Sample_1.xls
refer to O22, the answer become o, it should be 1000, how to solve it.
Thanks
May 2, 2010 at 11:10 AM
=IF(AND(OR(A7>=2, B7>=2,C7>=2,D7>=2), OR(E7>=2,F7>=2, G7>=2,H7>=2,I7>=2, J7>=2)),IF(AND(K7>=8,K7<=11),1000,IF(K7>=12,1500,0)),0)
May 2, 2010 at 11:14 AM
thanks
May 2, 2010 at 05:42 PM
May 3, 2010 at 06:50 AM