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

Occasional Contributor

Hello, I hope someone can assist me with this formula!


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 Replies
best response confirmed by Sergei Baklan (MVP)


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



awesome, it worked, thank you!