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

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