In H7 place the following formula:

=IF(NOT(ISBLANK(L7)),"Completed","")

That should do the trick.
--
Kevin Backmann
Dallas, TX


"btyler" wrote:

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.