Forum Discussion
Solved
Conditional IF AND/OR
Hi, I am working on a spreadsheet and I have a formula that I want to add in a conditional situation. This is what I have: =IF(OR(K12="",L12=""),"",IF(AND(K12="A",L12>=50,L12<=250),"Yes",...
=IF(M12="N","No",
IF(OR(K12="",L12=""),"",
IF(AND(K12="A",L12>=50,L12<=250),"Yes","No")))
If i correctly understand what you want to do, you can apply above formula. I changed data validation for cell M12 from Y/N to Y;N in order to select either "Y" or "N".
=IF(M12="N","No",
IF(OR(K12="",L12=""),"",
IF(AND(K12="A",L12>=50,L12<=250),"Yes","No")))
If i correctly understand what you want to do, you can apply above formula. I changed data validation for cell M12 from Y/N to Y;N in order to select either "Y" or "N".
Perfect! Thank you so much!