Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with 3 options
Good day,
I would like to know if any formula would work for the following. A B C D 6 YES 20DEC 20JAN 1.If a,b,c,d are all like above then E should be D + 2 months. 2.If A are 0, then D are 0. 3.I B are No, then E should be C + 6 months. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF with 3 options
A B C D
6 YES 20DEC 20JAN 1.If a,b,c,d are all like above then E should be D + 2 months. You need to clarify that. Does that mean that C should *always* be 20DEC and D should *always* be 20JAN? Are 20DEC and 20JAN real dates formatted to display like that or are they TEXT entries? Based on your explanation of the above what result do you expect? -- Biff Microsoft Excel MVP "ekkeindoha" wrote in message ... Good day, I would like to know if any formula would work for the following. A B C D 6 YES 20DEC 20JAN 1.If a,b,c,d are all like above then E should be D + 2 months. 2.If A are 0, then D are 0. 3.I B are No, then E should be C + 6 months. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I add more toolbar options to my right click options | Excel Discussion (Misc queries) | |||
Options | Excel Discussion (Misc queries) | |||
Web Options? | Excel Discussion (Misc queries) | |||
FTP options | Excel Discussion (Misc queries) | |||
what are my options? | Excel Discussion (Misc queries) |