Conditional text in Excel when a cell has a value

This might seem trivial to us 'developer' types, but it was today's "Jane's Excel question".

You have one or more cells in a spread sheet. You want to display some text "Y" or "N" depending on whether the cell has anything in it. eg.

image

One solution is to use this formula:

=IF(LEN(B3)>0, "Y", "N")

This checks the length of the text in the cell. An empty cell will have a length of zero. Anything greater than zero means the cell has something in it.

Written on September 21, 2010