Mod-Test

[schauansi]

  
Code:
C2:  =QUOTIENT(A2;100)

D2:  =15+WENN(B2>0;0;QUOTIENT(3*C2+3;4)-QUOTIENT(8*C2+13;25))

E2:  =WENN(B2>0;0;2-QUOTIENT(3*C2+3;4))

F2:  =REST(A2;19)

G2:  =REST(19*F2+D2;30)

H2:  =QUOTIENT(G2;29)+(QUOTIENT(G2;28)-QUOTIENT(G2;29))*QUOTIENT(F2;11)

I2:  =21+G2-H2

J2:  =7-REST(A2+QUOTIENT(A2;4)+E2;7)

K2:  =7-REST(I2-J2;7)

L2:  =WENN(B2=2;QUOTIENT(A2;100)-QUOTIENT(A2;400)-2;0)