I need to make an IF statement with four outcomes.
The selected cell will be filled in with a number and then looked up against a long range of numbers in another sheet called "Risk".
The outcomes should be "Low Risk", "Medium Risk", "High Risk" and "No go".
A3:A2410 = Low Risk
A2413:A2671 = Medium Risk
A2675:A2954 = High Risk
A2956:A2975 = No go
What I have tried:
I have tried making the IF statement myself, but without luck..
Here is my statement:
=IF(E3=Risk!A3:A2410,"Low Risk",IF(E3=Risk!A2413:2671,"Medium Risk", IF(E3=Risk!A2675:2954, "High risk", "No go")))