Forum Discussion

jamesvinicombe's avatar
jamesvinicombe
Copper Contributor
Jul 15, 2022
Solved

=IF(A1="3","x","") WHY IS CELL BLANK?

Hello, I hope someone can assist me with this formula! =IF(A1="3","x","") A1 is a cell with a SUM in it. And the cell that I put the formula in is blank at the moment, any ideas what to do? ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 15, 2022

    jamesvinicombe 

    A sum is a number, but "3" is text. Change the formula to

     

    =IF(A1=3,"x","")

HansVogelaar's avatar
HansVogelaar
MVP
Jul 15, 2022

jamesvinicombe 

A sum is a number, but "3" is text. Change the formula to

 

=IF(A1=3,"x","")

  • jamesvinicombe's avatar
    jamesvinicombe
    Copper Contributor
    Jul 15, 2022
    awesome, it worked, thank you!