Hello,
I need help understanding the nested IF Statement below in the attached XLS documents. Can anyone advise?
=IF($E3=0,0,IF(IF(((Z$2-$A3)>=365),IF((((Z$2-$A3)-365)<=(Z$2-Y$2)),((140/12)*(((Z$2-$A3)-365)/(Z$2-Y$2))),IF(((Z$2-$A3)>=1096),((140/12)*((1096-(Y$2-$A3))/((Z$2-Y$2)+1))),(140/12))),IF((Y$2<$A3),IF(($A3<=Z$2),($E3-280),0),0))<0,0,IF(((Z$2-$A3)>=365),IF((((Z$2-$A3)-365)<=(Z$2-Y$2)),((140/12)*(((Z$2-$A3)-365)/(Z$2-Y$2))),IF(((Z$2-$A3)>=1096),((140/12)*((1096-(Y$2-$A3))/((Z$2-Y$2)+1))),(140/12))),IF((Y$2<$A3),IF(($A3<=Z$2),($E3-280),0),0))*$B3))
Bookmarks