KH219
08-19-2022, 06:13 AM
Hi,
I've been trying to work this for ages and I just can't seem to fathom it. I'm very new to this so I'm a bit clueless.
I'm trying to quickly insert a value in a column based on 2 other columns
E.g.
Condition Score
Number of Problem s
Overall score
1
1
2
5
3
4
4
10
My rules are as follows:
If Condition Score is 1 and Number of problems is >= 0 or <=2 Then Overall Score is 1, if number of problems is outside of this range then the overall score is 5
If Condition Score is 2 and Number of problems is >=3 or <=7 Then Overall Score is 1, if number of problems is outside of this range then the overall score is 5
If Condition Score is 3 and Number of problems is >=8 or <=10 Then Overall Score is 1, if number of problems is outside of this range then the overall score is 5
If Condition Score is 4 and Number of problems is >=11 or <=15 Then Overall Score is 1, if number of problems is 10 or 16 then the overall score is 3, and if the number of problems are outside of these ranges then the overall score is 5
Can someone please help? I have about 100000 cells to process
I've been trying to work this for ages and I just can't seem to fathom it. I'm very new to this so I'm a bit clueless.
I'm trying to quickly insert a value in a column based on 2 other columns
E.g.
Condition Score
Number of Problem s
Overall score
1
1
2
5
3
4
4
10
My rules are as follows:
If Condition Score is 1 and Number of problems is >= 0 or <=2 Then Overall Score is 1, if number of problems is outside of this range then the overall score is 5
If Condition Score is 2 and Number of problems is >=3 or <=7 Then Overall Score is 1, if number of problems is outside of this range then the overall score is 5
If Condition Score is 3 and Number of problems is >=8 or <=10 Then Overall Score is 1, if number of problems is outside of this range then the overall score is 5
If Condition Score is 4 and Number of problems is >=11 or <=15 Then Overall Score is 1, if number of problems is 10 or 16 then the overall score is 3, and if the number of problems are outside of these ranges then the overall score is 5
Can someone please help? I have about 100000 cells to process