View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Browny Browny is offline
external usenet poster
 
Posts: 40
Default Combining 2 IF statements

I record a date in 'A1' when I receive registered documents.
My 'IF' statement in C1 then adds "working on file" in C1.
I then record a date in B1 when I forward the file on.
I wish to replace the "working on file" statement with "passed" when a date
is entered into B1.
I tried =IF(A1&B11,"PASSED",IF(A11,"working on file","") but it doesn't
work.
Can you help?

--
Browny