Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combining VLookup and IF statements | Excel Discussion (Misc queries) | |||
If Statements & Combining Cells | Excel Worksheet Functions | |||
Combining IF Statements | Excel Worksheet Functions | |||
Combining IF statements | Excel Worksheet Functions | |||
combining conditional statements | Excel Worksheet Functions |