N
N E Body
Hi
I cannot get my head round this one at all
I want to enter a formula into a cell <eg C1> to return a value of
"Complete" if A1 is a number and B1 is not blank.
If A1 is a number and B1 is blank C1 value is "Outstanding"
if A1 is blank then C1 is " " <empty>
Any Ideas?
Regards
Kenny
Win NT and 2000 with Office 97
I cannot get my head round this one at all
I want to enter a formula into a cell <eg C1> to return a value of
"Complete" if A1 is a number and B1 is not blank.
If A1 is a number and B1 is blank C1 value is "Outstanding"
if A1 is blank then C1 is " " <empty>
Any Ideas?
Regards
Kenny
Win NT and 2000 with Office 97