SOLVED

# If formula

Copper Contributor

# 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

4 Replies

# Re: If formula

=IF(OR(AND(B2="Above",C2>16),AND(B2="Below",C2>25)),"yes","no")

# Re: If formula

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.

best response confirmed by HannahKing (Copper Contributor)
Solution

# Re: If formula

=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.

# Re: If formula

Thanks very much. That's my bad - I previously had a header. It works now :)

1 best response

Accepted Solutions
best response confirmed by HannahKing (Copper Contributor)
Solution

# Re: If formula

=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.