If formula evaluating 2 cells contents

  • Thread starter Thread starter N E Body
  • Start date Start date
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
 
One way:

Assuming A1 will be either a number or blank:

=IF(ISBLANK(A1),"",IF(ISBLANK(B1),"Outstanding","Complete"))

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

=IF(ISBLANK(A1), "", IF(ISNUMBER(A1), IF(ISBLANK(B1),
"Outstanding", "Complete"), "Something Else"))
 
Try this formula in cell C1.

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

Hope this helps.

Thanks,
Bill Horton
 
Many thanks - works a treat (and my attempts looked nothing like these
examples!!! <VBG>)

Regards
Kenny
 
Back
Top