SOLVED

IF Formula Advice

%3CLINGO-SUB%20id%3D%22lingo-sub-2000432%22%20slang%3D%22en-US%22%3EIF%20Formula%20Advice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2000432%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20am%20a%20very%20novice%20Excel%20user%20here.%20I%20am%20looking%20to%20create%20a%20simple%20checklist%20where%20if%20I%20place%20an%20%22X%22%20in%20a%20cell%2C%20I%20get%20an%20%22X%22%20in%20a%20corresponding%20cell%20in%20another%20column.%20I%20have%20used%20this%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20cell%20B4%3A%3C%2FP%3E%3CP%3E%3DIF(D4%3D%22X%22%2C%22X%22%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%2C%20I%20would%20like%20the%20formula%20to%20work%20for%20each%20row--%20such%20that%20if%20there%20is%20an%20%22X%22%20in%20any%20one%20of%20the%20columns%20(D%20through%20F)%20for%20a%20given%20row%2C%20the%20value%20would%20return%20an%20%22X%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20does%20not%20work%3A%3C%2FP%3E%3CP%3E%3DIF(D4%3AF4%3D%22X%22%2C%22X%22%2C%22%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20help!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F241529iF1A5F5A6BF59D53E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2000432%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2000467%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Formula%20Advice%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2000467%22%20slang%3D%22en-US%22%3ETry%3A%3CBR%20%2F%3E%3DIF(COUNTIF(D4%3AF4%2C%22X%22)%26gt%3B0%2C%22X%22%2C%22%22)%3C%2FLINGO-BODY%3E
New 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 (New 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.