Forum Discussion
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 also says yes. If not then no for both instances.
The formula in the picture is what I have so far, but it doesn't work. Any ideas?
Thanks,
Hannah
=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.
4 Replies
=IF(OR(AND(B2="Above",C2>16),AND(B2="Below",C2>25)),"yes","no")
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.
