Forum Discussion
Helena_BG
Jun 07, 2022Copper Contributor
Multiple IF statements for numerical scoring
Hi,
I would really appreciate if someone help me with the following goal:
- I want to obtain three scores (10, 5 or 1) according to the following results for the differences between two cells:
1) The absolute difference is between 0 and 20 inclusive - score 10
2) The absolute difference is between 20 and 40 inclusive - score 5
3) The absolute difference is superior to 40 - score 1
I put the formula: =IF(ABS(I2-H2)<=20, 10) OR(IF(AND(ABS(I2-H2))>20, ABS(I2-H2)<=40), 5) OR(IF(ABS(I2-H2)>40, 1)). But it didn't work. Could you please correct it/suggest another one?
Thank you in advance!
Helena
1 Reply
- OliverScheurichGold Contributor
=IF(ABS(I2-H2)<=20, 10,IF(AND(ABS(I2-H2)>20, ABS(I2-H2)<=40), 5, 1))Maybe with this formula.