Forum Discussion
Formula with text column
I am trying to set a formula in a column based on another column which will either have text in it or be blank. I can't seem to figure it out. How do I do it?
Perhaps something like
=IF( LEN(A1), one option, another option)If LEN(A1) is equal to zero that's equivalent of FALSE, all other of TRUE
SergeiBaklan That worked perfectly. Thank you!
adele318 , you are welcome