Forum Discussion
Formula error
Hi All, I was wondering if anyone would be able to point out what I doing wrongly as i have been struggling with this formula for a couple of hours. Synopsis Column 1 (Event date) = 13/06/24,...
Bauer2480 Please try this!
=IF(OR(AND(E2="A",F2<0.69,G2-I2>1),AND(E2="B",F2<=0.49,G2-I2>3)),"High Risk", IF(AND(E2="A",AND(F2>=0.69,F2<=0.99)),"Low Risk", IF(AND(E2="A",F2=1),"Great Job", IF(AND(E2="B",AND(F2>=0.5,F2<=0.99)),"Low Risk", IF(AND(E2="B",F2=1),"Great Job","Don’t know")))))