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
|