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

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

Try this formula in cell C1.

IF(AND(ISNUMBER(A1),NOT(ISBLANK(B1))),"Complete",I F(AND(ISNUMBER(A1),ISBLANK(B1)),"Outstanding",IF(I SBLANK(A1),"","Other Scenario")))

Hope this helps.

Thanks,
Bill Horton

"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

Many thanks - works a treat (and my attempts looked nothing like these
examples!!! <VBG)

Regards
Kenny

"JE McGimpsey" wrote in message
...
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