Jul 15 2022 11:32 AM
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!
Jul 15 2022 11:37 AM
SolutionJul 15 2022 11:37 AM
SolutionA sum is a number, but "3" is text. Change the formula to
=IF(A1=3,"x","")