Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If combined with OR & AND
Cell E14 contains a date and I want certain things to happen if the date is
equal to certain criteria. I'm having problems with the syntax. IF(E14="1/31/2008",0,if(AND(e14<"1/31/2008",e14"1/14/2007",L14/12,if(AND(e14<"1/15/2008",e14"12/31/2007",L14/24))))) Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combined ROUNDUP | Excel Worksheet Functions | |||
Combined Statements | Excel Discussion (Misc queries) | |||
Sort by Last Name when name is combined | Excel Worksheet Functions | |||
Combined Cells | Excel Worksheet Functions | |||
Combined IF statement... | Excel Worksheet Functions |