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

[jamesvinicombe]

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?

Thanks for your help!

[#2 · Accepted solution]

@jamesvinicombe 

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

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

[#3]

awesome, it worked, thank you!