If(and( & n/a

[Bugner]

I am having trouble getting an IF)AND statement to work

=IF(AND(J12=5,K12="Y"),"5Y",J12)

In cell J12, value can be 1 to 5 in cell K12 I have a match formula referencing another cell so either Y or #N/A is returned.

so I was hopng that if J12 =5 and K12 = Y then 5Y is displayed, otherwise just display what is in cell J12.

Formula only displays what is in J12 if there is a Y in K12?

Not sure why, as surely that equates to a value if false based on the IF(AND?

I am obvioulsy missing something? Any help appreciated.

TIA

 

[BarryL]

Are you saying that if J12 = 4 & K12 = "N" then your formula is giving "5Y"??

I copied your formula exactly and i think it should work. Do you by any chance have your calculation set to manual?

 

[Fluff]

How about
=IF(AND(J12=5,NOT(ISNA(K12))),"5Y",J12)