Related:

- Incentive Calculation with few Condition
- Mtu calculator - How-To - Network
- Android scientific calculator - How-To - Android
- Excel conditional formatting based on date in another cell - How-To - Excel
- Available memory less than 15mb condition zero - How-To - Counter Strike
- Percentage to paisa calculator - Forum - Office Software

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

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
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

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.

rizvisa1

- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020

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

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.

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

=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)

thanks