User Profile
nleven
Copper Contributor
Joined Dec 17, 2020
User Widgets
Recent Discussions
IF Formula Advice
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!!
