IF with 3 options

E

ekkeindoha

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
 
T

T. Valko

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.
Click to expand...

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?
 
Top