Forum Discussion

nleven's avatar
nleven
Copper Contributor
Dec 17, 2020
Solved

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 formul...
excel
Formulas and Functions
  • JMB17's avatar
    JMB17
    Dec 17, 2020
    Try:
    =IF(COUNTIF(D4:F4,"X")>0,"X","")
JMB17's avatar
JMB17
Bronze Contributor
Dec 17, 2020
Try:
=IF(COUNTIF(D4:F4,"X")>0,"X","")
nleven's avatar
nleven
Copper Contributor
Dec 17, 2020
Thank you very much!!! I appreciate the help and the learning.
  • JMB17's avatar
    JMB17
    Bronze Contributor
    Dec 17, 2020
    You are quite welcome.