| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Not sure how to format this if statement
I'm having difficulty forming this statement and would be grateful for
assistance. Cell D1 contains the formula If cell A1 is empty then cell D1 remains empty If cell A1 contains a date and cell B1 is empty then cell D1 returns "Outstanding" If cell A1 contains a date and cell B1 contains text then cell D1 remains empty If cell A1 contains a date and cell B1 is empty and cell C1 contains a date then cell D1 returns "Cleared" Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| why does currency format change to number format? | Excel Discussion (Misc queries) | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
| Copying a conditional format | Excel Worksheet Functions | |||
Threaded Mode
