Forum Discussion
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: ...
=IF(ABS(I2-H2)<=20, 10,IF(AND(ABS(I2-H2)>20, ABS(I2-H2)<=40), 5, 1))Maybe with this formula.