Dec 17 2020 10:25 PM
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!!
Dec 17 2020 10:48 PM
Dec 17 2020 10:42 PM
Solution