Bar-kodovi, računanje kontrolne 13-te cifre u Excelu

=A2&(ROUNDUP(((MID(A2,2,1)+MID(A2,4,1) +MID(A2,6,1)+MID(A2,8,1)+MID(A2,10,1)+MID(A2,12,1))*3) +(MID(A2,1,1)+MID(A2,3,1)+MID(A2,5,1)+MID(A2,7,1) +MID(A2,9,1)+MID(A2,11,1)),-1)-(((MID(A2,2,1)+MID(A2,4,1) +MID(A2,6,1)+MID(A2,8,1)+MID(A2,10,1)+MID(A2,12,1))*3) +(MID(A2,1,1)+MID(A2,3,1)+MID(A2,5,1)+MID(A2,7,1) +MID(A2,9,1)+MID(A2,11,1))))

2019-07-05T01:23:22+02:0030.06.2019|

Sistemske opcije

INIT PRG............ -1 ACC................. (X) DEBUG............... (X) / (X) PROVERA [...]

2019-05-09T16:28:04+02:0030.03.2017|

(APP Help) Nema help

TRAŽENE INFORMACIJE NE POSTOJEZa indeks tema pritisnite ponovo taster F1.

2016-10-11T14:21:55+02:0011.10.2016|
Go to Top