SOLVED

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

Occasional Contributor

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

@jamesvinicombe 

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

 

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

awesome, it worked, thank you!