View Single Post
  #1   Report Post  
N E Body
 
Posts: n/a
Default 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