SOLVED

IF Formula Advice

Copper Contributor

Hello, I am a very novice Excel user here. I am looking to create a simple checklist where if I place an "X" in a cell, I get an "X" in a corresponding cell in another column. I have used this formula:

 

For cell B4:

=IF(D4="X","X","")

 

However, I would like the formula to work for each row-- such that if there is an "X" in any one of the columns (D through F) for a given row, the value would return an "X".

 

This does not work:

=IF(D4:F4="X","X","")

 

Thank you for the help!!

 

Capture.PNG

3 Replies
best response confirmed by nleven (Copper Contributor)
Solution
Try:
=IF(COUNTIF(D4:F4,"X")>0,"X","")
Thank you very much!!! I appreciate the help and the learning.
You are quite welcome.
1 best response

Accepted Solutions
best response confirmed by nleven (Copper Contributor)
Solution
Try:
=IF(COUNTIF(D4:F4,"X")>0,"X","")

View solution in original post