Nested if(AND)

Question

I have 3 Columns that I need to match three other columns to complete the process. Such as: A=B and C=D and E=F. If all of these are true annotate N, otherwise leave blank.

Answer 1

Hi @Kayanne Schauberger, 

Thank you for posting your question in the Microsoft Q&A forum. 

Assuming the following setup: 

• Columns A, C, E contain your original values 
• Columns B, D, F contain the values to match 
• You want the result in Column G 

You can use this formula in cell G1:  

=IF(AND(A1=B1,C1=D1,E1=F1),"N","")  

then drag the formula down to apply it to all rows in Column G. 

Explanation:  

• AND(A1=B1, C1=D1, E1=F1) checks whether all three conditions are TRUE. 
• If TRUE, the formula returns "N". 
• If FALSE, it returns a blank cell (""). 

This approach is simple and effective for comparing multiple columns row by row. 

If you have any updates or further questions, feel free to leave a comment under this post. I’ll be happy to continue assisting you. 

Thank you for your time, and I hope this helps! 

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". 

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.