Kevin, Many thanks for your help that worked great.

In my H7 cell I also managed to write an 'IF' formula as follows:
=IF(I70,"OVERDUE","Not Due") how could I incorporate the foluma you have
just given me to work with my IF formula.

Basicly I want my IF formula to work 1st but as soon as something is
entered into L7 i want that rule to take president.

i tried this but had no luck =IF(I70,"OVERDUE","Not Due") +
=IF(NOT(ISBLANK(L7)),"Completed","")

Many Thanks





"Kevin B" wrote:

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.