If/or/and

[kizzie37]

Ok, so i have a slightly complex If/OR/AND that I cant get to work

If the value in g3 is = to 1 OR G3 between 2 and 10), then yes, or No

=IF(AND(G3="20700",(IF(OR(AH8>=60200,AH8<=70855),"yes","no")),"yes","no")

I think this is close, but it is missing ",

can anyone help with the correct formula string?

 

[kizzie37]

sorry, that should read

=IF(OR(G3="20700",(IF(OR(G38>=60200,G3<=70855)),"yes","no")))

 

[jai9]

Hi,

Try,

=IF(OR(G3="20700",G38>=60200,G3<=70855),"yes","no")

I think the "20700" should be 20700.

Also, in first post you said

If the value in g3 is = to 1 OR G3 between 2 and 10), then yes, or No

The actual formula says totally different thing.

Jai

 

[kizzie37]

OK, so what is correct bascically I have to match a cell to either single numbers, or in a range of numbers, eg:

G3 is equal to 1 and h3 between 2 and 10, then Yes