SOLVED

FALSE HOW DO YOU HIDE IT

Copper Contributor

Hi this is my formula? =IF(E14="X", "X") but if there is no X the cell E14 returns FALSE. How do I hide the false?

Thank you in advance for your help

 

PC/Windows 10, 64 bit, Microsoft 365, Excel Version 2108

3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution
=IF(E14="X", "X","")

Thank you so much exactly what I needed @Juliano-Petrukio 

Any time. Please flag it as solved.
1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution
=IF(E14="X", "X","")

View solution in original post