| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not sure how to format this if statement
I've kept this simple by assuming:
A1 & C1 can only be empty or contain a date and any entry into B1 will only be a comment (text) =if(A1 = "","",if(and(A1<"",b1="",c1=""),"Outstanding",if( and(A1<"",B1<"",C1=""),"",if(and(A1<"",B1="",C1 <""),"Cleared","ERROR!")))) I've added the error condition in case an operator should fail to erase B1 when adding a date to C1. HTH Giz "jimar" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Not sure how to format this if statement
Thanks very much this is exactly what I needed.
"Gizmo63" wrote: I've kept this simple by assuming: A1 & C1 can only be empty or contain a date and any entry into B1 will only be a comment (text) =if(A1 = "","",if(and(A1<"",b1="",c1=""),"Outstanding",if( and(A1<"",B1<"",C1=""),"",if(and(A1<"",B1="",C1 <""),"Cleared","ERROR!")))) I've added the error condition in case an operator should fail to erase B1 when adding a date to C1. HTH Giz "jimar" wrote: 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 |
| Reply |
| 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 | |||
Hybrid Mode
