If formula evaluating 2 cells contents
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
|