IF both of two conditions exist, I want to post a Y to a cel...

[subrostud]

I tried this and received an error message:

=IF(AND ((CH>17 OR CG>17) AND (AJ>25 OR AY=+1)), "Y"))

I want the numerical result in column CH to exceed 17, OR the result in CG to exceed 17; either result satisfies that condition,
AND
if either the result in AJ>25 OR AY equals 1, then
I want Y inserted in a cel.

But, I cannot figure out what error I made in the above function. Help!

Stephen aka subrostud

[Pete_UK]

There are several errors - you need to refer to specific cells and not to column identifiers, and you have the syntax wrong for the OR function. Try it like this:

=IF(AND(OR(CH2>17,CG2>17),OR(AJ2>25,AY2=1)),"Y","")

I've assumed that this is looking at the cells in row 2, so you would normally put this in another cell in row 2, and then copy it down if required.

Hope this helps.

Pete

[dredwolf]

maybe try this :

=IF(AND(OR(CH>17,CG>17),OR(AJ>25,AY=1)),"Y","")

[dredwolf]

oops , sorry Pete

[Pete_UK]

oops , sorry Pete

No problem - it happens all the time to me.

Pete

[subrostud]

[QUOTE=Pete_UK;2995312]There are several errors - you need to refer to specific cells and not to column identifiers, and you have the syntax wrong for the OR function. Try it like this:

=IF(AND(OR(CH2>17,CG2>17),OR(AJ2>25,AY2=1)),"Y","")

I've assumed that this is looking at the cells in row 2, so you would normally put this in another cell in row 2, and then copy it down if required.

Hope this helps.

Pete

Pete:

Both conditions have to exist to return a "Y" value. I changed the middle "OR" to "AND", and there's still a #VALUE! error.

[Pete_UK]

I'm not sure why you would get a #VALUE error with that formula, as you are not attempting to do arithmetic on text values. Are you sure you typed it in correctly, with all the parentheses and commas?

Pete

[dredwolf]

subrostud, I think you may be mis-understanding how AND and OR work in Excel, they are not operators, but Functions,
so a statemen of " IF (this OR this) AND (that OR that)..."
translates, in EXCEL as "IF(AND(OR(this,this),OR(that,that))..."
hope that helps