Forum Discussion
Help on Excel IF Condition with AND or OR statement
Good afternoon, I need help with the following IF statement as it is not working as I want it to. =IF(AND(E1=”Carbon”,OR((F1<0.5,F1>2.1,G1<0,G1>1.5,H1<0,H1>0.5,I<=0,I1>0.3,J<0,J15>0.25,K1<0,K1>...
Hi Gourab,
I have uploaded the sheet and what I want is the data from E15 to K15 section which is not working on the following formula
=IF(AND((E1="Carbon"),NOT(OR(F1<0.5,F1>2.1,G1<0,G1>1.5,H1<0,H1>0.5,I1<=0,I1>0.3,J1<0,J1>0.25,K1<0,K1>1.5))),"PASS",
IF(AND((E1="Alloy"),NOT(OR(F1<0.5,F1>1.5,G1<0,G1>5,H1<0,H1>1,I1<0,I1>1,J1<2,J1>5,K1<11,K1>15))),"PASS",
"FAIL"))
Hi Adam Jalil
Sorry but I cant make out your criteria ie F1<0.5,F1>1.5 here the value could be anything . Please clear the issue.
Sorry but I cant make out your criteria ie F1<0.5,F1>1.5 here the value could be anything . Please clear the issue.
Hi Gourab, The values were in %... I have it working now so thank you for assisting me on this matter.
Regards
Adam