Forum Discussion
Solved
If formula
Hi, I am trying to write a formula so that if B2 says above and C2 is equal to or greater than 16 then D2 says yes, but also if B2 says below and C2 is equal to or greater than 25 then D2 a...
=IF(OR(AND(B1="Above",C1>=16),AND(B1="Below",C1>=25)),"yes","no")
You are welcome. I didn't understand that the data starts in row 1 since i saw cells B2 and C2 in the screenshot of the initial question.
Hi Oliver,
Thanks for your help. The formula is still not quite working as you can see.
It should go no, yes, no, no, yes I think. Any ideas? Thanks.
=IF(OR(AND(B1="Above",C1>=16),AND(B1="Below",C1>=25)),"yes","no")
You are welcome. I didn't understand that the data starts in row 1 since i saw cells B2 and C2 in the screenshot of the initial question.
Thanks very much. That's my bad - I previously had a header. It works now 🙂