I have this formula in cell V2:
=IF((OR(A2=1,A2=3,A2=4)),( IF(U2<>0,(EDATE(U2,3)),IF(U2<>0,(EDATE(U2,3)), 0))),"No Data")
I need to put an expression in the above formula that allows for when A2=5, which I'm working on below.
=IF((A2=5),( IF(U2<>0,(EDATE(U2,12)),IF(U2<>0,(EDATE(U2,12)), 0))),"No Data")
This is getting a little "out of hand" for me... can someone offer some assistance?![]()
Thanks.
Bookmarks