Kako da uprostim ovu funkciju, prevelika je i ne moze excel da je prihvati?
Code:
=IF( $A4 = "", "",IF(YEAR($C$2)=YEAR($A4),
IF( AND(YEAR(k2d)=YEAR($A4), k2d>$A4), DATE(YEAR(k2d),MONTH(k2d),DAY(k2d)-1),
IF( AND(YEAR(K3D)=YEAR($A4), K3D>$A4), DATE(YEAR(K3D),MONTH(K3D),DAY(K3D)-1),
IF( AND(YEAR(K4D)=YEAR($A4), K4D>$A4), DATE(YEAR(K4D),MONTH(K4D),DAY(K4D)-1),
IF( AND(YEAR(K5D)=YEAR($A4), K5D>$A4), DATE(YEAR(K5D),MONTH(K5D),DAY(K5D)-1),
IF( AND(YEAR(K6D)=YEAR($A4), K6D>$A4), DATE(YEAR(K6D),MONTH(K6D),DAY(K6D)-1),
IF( AND(YEAR(K7D)=YEAR($A4), K7D>$A4), DATE(YEAR(K7D),MONTH(K7D),DAY(K7D)-1),
IF( AND(YEAR(K8D)=YEAR($A4), K8D>$A4), DATE(YEAR(K8D),MONTH(K8D),DAY(K8D)-1),
IF( AND(YEAR(K9D)=YEAR($A4), K9D>$A4), DATE(YEAR(K9D),MONTH(K9D),DAY(K9D)-1),
IF( AND(YEAR(K1E)=YEAR($A4), K1E>$A4), DATE(YEAR(K1E),MONTH(K1E),DAY(K1E)-1),
IF( AND(YEAR(K2E)=YEAR($A4), K2E>$A4), DATE(YEAR(K2E),MONTH(K2E),DAY(K2E)-1),
IF( AND(YEAR(K3E)=YEAR($A4), K3E>$A4), DATE(YEAR(K3E),MONTH(K3E),DAY(K3E)-1),
IF( AND(YEAR(K4E)=YEAR($A4), K4E>$A4), DATE(YEAR(K4E),MONTH(K4E),DAY(K4E)-1),
IF( AND(YEAR(K5E)=YEAR($A4), K5E>$A4), DATE(YEAR(K5E),MONTH(K5E),DAY(K5E)-1),
IF( AND(YEAR(K6E)=YEAR($A4), K6E>$A4), DATE(YEAR(K6E),MONTH(K6E),DAY(K6E)-1),
IF( AND(YEAR(K7E)=YEAR($A4), K7E>$A4), DATE(YEAR(K7E),MONTH(K7E),DAY(K7E)-1),
IF( AND(YEAR(K8E)=YEAR($A4), K8E>$A4), DATE(YEAR(K8E),MONTH(K8E),DAY(K8E)-1),
IF( AND(YEAR(K9E)=YEAR($A4), K9E>$A4), DATE(YEAR(K9E),MONTH(K9E),DAY(K9E)-1),
IF( AND(YEAR(K10E)=YEAR($A4), K10E>$A4), DATE(YEAR(K10E),MONTH(K10E),DAY(K10E)-1),$C$2))))))))))))))))),
IF( AND(YEAR(k2d)=YEAR($A4), k2d>$A4), DATE(YEAR(k2d),MONTH(k2d),DAY(k2d)-1),
IF( AND(YEAR(K3D)=YEAR($A4), K3D>$A4), DATE(YEAR(K3D),MONTH(K3D),DAY(K3D)-1),
IF( AND(YEAR(K4D)=YEAR($A4), K4D>$A4), DATE(YEAR(K4D),MONTH(K4D),DAY(K4D)-1),
IF( AND(YEAR(K5D)=YEAR($A4), K5D>$A4), DATE(YEAR(K5D),MONTH(K5D),DAY(K5D)-1),
IF( AND(YEAR(K6D)=YEAR($A4), K6D>$A4), DATE(YEAR(K6D),MONTH(K6D),DAY(K6D)-1),
IF( AND(YEAR(K7D)=YEAR($A4), K7D>$A4), DATE(YEAR(K7D),MONTH(K7D),DAY(K7D)-1),
IF( AND(YEAR(K8D)=YEAR($A4), K8D>$A4), DATE(YEAR(K8D),MONTH(K8D),DAY(K8D)-1),
IF( AND(YEAR(K9D)=YEAR($A4), K9D>$A4), DATE(YEAR(K9D),MONTH(K9D),DAY(K9D)-1),
IF( AND(YEAR(K1E)=YEAR($A4), K1E>$A4), DATE(YEAR(K1E),MONTH(K1E),DAY(K1E)-1),
IF( AND(YEAR(K2E)=YEAR($A4), K2E>$A4), DATE(YEAR(K2E),MONTH(K2E),DAY(K2E)-1),
IF( AND(YEAR(K3E)=YEAR($A4), K3E>$A4), DATE(YEAR(K3E),MONTH(K3E),DAY(K3E)-1),
IF( AND(YEAR(K4E)=YEAR($A4), K4E>$A4), DATE(YEAR(K4E),MONTH(K4E),DAY(K4E)-1),
IF( AND(YEAR(K5E)=YEAR($A4), K5E>$A4), DATE(YEAR(K5E),MONTH(K5E),DAY(K5E)-1),
IF( AND(YEAR(K6E)=YEAR($A4), K6E>$A4), DATE(YEAR(K6E),MONTH(K6E),DAY(K6E)-1),
IF( AND(YEAR(K7E)=YEAR($A4), K7E>$A4), DATE(YEAR(K7E),MONTH(K7E),DAY(K7E)-1),
IF( AND(YEAR(K8E)=YEAR($A4), K8E>$A4), DATE(YEAR(K8E),MONTH(K8E),DAY(K8E)-1),
IF( AND(YEAR(K9E)=YEAR($A4), K9E>$A4), DATE(YEAR(K9E),MONTH(K9E),DAY(K9E)-1),
IF( AND(YEAR(K10E)=YEAR($A4), K10E>$A4), DATE(YEAR(K10E),MONTH(K10E),DAY(K10E)-1),DATE(YEAR($A4),12,31)))))))))))))))))))))
U Sheet _koef. se nalazi k2d K3D K4D K5D K6D K7D K8D K9D K1E K2E K3E K4E K5E K6E K7E K8E K9E K10E
[Ovu poruku je menjao 3okc dana 15.06.2011. u 21:00 GMT+1]