Formula with text column

[adele318]

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?

[#2]

@adele318 

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

[#3]

@Sergei Baklan That worked perfectly. Thank you!

[#4]

@adele318 , you are welcome