Thread: If(and( & n/a Thanks: 0 Likes: 0

1. If(and( & n/a

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  Reply With Quote

2. Re: If(and( & n/a

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?  Reply With Quote

3. Re: If(and( & n/a

=IF(AND(J12=5,NOT(ISNA(K12))),"5Y",J12)  Reply With Quote

User Tag List

Tags for this Thread

cell, formula, ifand, j12, k12  Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•