Hi,

I require help with a formula, I'm tring to get the cell H7 to return a
result of "completed" if the cell L7 hold anytype of value either text or
number.

If L7 is blank then H7 will also remain blank.

Any help would be much appreciated.