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".
May I make a request: put some data--it can be dummy data if need be--into a few of the rows of this sample spreadsheet.
In the absence of any representative data, it's hard (for me, at any rate) to do a realistic appraisal of what you've written, why it might work or not....