Forum Discussion

Helena_BG's avatar
Helena_BG
Copper Contributor
Jun 07, 2022

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

Resources