One way:

Assuming A1 will be either a number or blank:

=IF(ISBLANK(A1),"",IF(ISBLANK(B1),"Outstanding","C omplete"))

If A1 can be something other than a number or blank:

=IF(ISBLANK(A1), "", IF(ISNUMBER(A1), IF(ISBLANK(B1),
"Outstanding", "Complete"), "Something Else"))


In article ,
"N E Body" wrote:

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