|
Célula |
Fórmula
|
Célula
|
Fórmula
|
Célula |
Fórmula
|
|
B16 |
=B3 |
F16 |
=B16+C16+D16-E16 |
F28 |
=F25*0,08 |
|
B17 |
=B4 |
F17 |
=B17+C17+D17-E17 |
G28 |
=F25*0,2 |
|
B18 |
=B5 |
F18 |
=B18+C18+D18-E18 |
H28 |
=F25*0,058 |
|
B19 |
=B6 |
F19 |
=B19+C19+D19-E19 |
I28 |
=F25*0,02 |
|
B20 |
=B7 |
F20 |
=B20+C20+D20-E20 |
J28 |
=G28+H28+I28 |
|
B21 |
=B8 |
F21 |
=B21+C21+D21-E21 |
K28 |
=J28+J25 |
|
B22 |
=B9 |
F22 |
=B22+C22+D22-E22 |
L28 |
=I25 |
|
B23 |
=B10 |
F23 |
=B23+C23+D23-E23 |
M28 |
=K28-L28 |
|
B25 |
=SOMA(B16:B23) |
F25 |
=SOMA(F16:F24) |
I25 |
=SOMA(I16:I24) |
|
C16 |
=B16/220*C3*1,5 |
G16 |
=H3*1,4 |
M16 |
=H16-2 |
|
C17 |
=B17/220*C4*1,5 |
G17 |
=H4*1,4 |
M17 |
=H17-2 |
|
C18 |
=B18/220*C5*1,5 |
G18 |
=H5*1,4 |
M18 |
=H18-2 |
|
C19 |
=B19/220*C6*1,5 |
G19 |
=H6*1,4 |
M19 |
=H19-2 |
|
C20 |
=B20/220*C7*1,5 |
G20 |
=H7*1,4 |
M20 |
=H20-2 |
|
C21 |
=B21/220*C8*1,5 |
G21 |
=H8*1,4 |
M21 |
=H21-2 |
|
C22 |
=B22/220*C9*1,5 |
G22 |
=H9*1,4 |
M22 |
=H22-2 |
|
C23 |
=B23/220*C10*1,5 |
G23 |
=H10*1,4 |
M23 |
=H23-2 |
|
C25 |
=SOMA(C16:C24) |
G25 |
=SOMA(G16:G24) |
M25 |
=SOMA(M16:M24) |
|
D16 |
=B16/220*D3*2 |
H16 |
=I3*25 |
N16 |
=F16+G16+H16+I16-J16-K16-L16-M16 |
|
D17 |
=B17/220*D4*2 |
H17 |
=I4*25 |
N17 |
=F17+G17+H17+I17-J17-K17-L17-M17 |
|
D18 |
=B18/220*D5*2 |
H18 |
=I5*25 |
N18 |
=F18+G18+H18+I18-J18-K18-L18-M18 |
|
D19 |
=B19/220*D6*2 |
H19 |
=I6*25 |
N19 |
=F19+G19+H19+I19-J19-K19-L19-M19 |
|
D20 |
=B20/220*D7*2 |
H20 |
=I7*25 |
N20 |
=F20+G20+H20+I20-J20-K20-L20-M20 |
|
D21 |
=B21/220*D8*2 |
H21 |
=I8*25 |
N21 |
=F21+G21+H21+I21-J21-K21-L21-M21 |
|
D22 |
=B22/220*D9*2 |
H22 |
=I9*25 |
N22 |
=F22+G22+H22+I22-J22-K22-L22-M22 |
|
D23 |
=B23/220*D10*2 |
H23 |
=I10*25 |
N23 |
=F23+G23+H23+I23-J23-K23-L23-M23 |
|
D25 |
=SOMA(D16:D24) |
H25 |
=SOMA(H16:H24) |
N25 |
=SOMA(N16:N24) |
|
E16 |
=B16/220*E3 |
L16 |
=G16*0,06 |
B27 |
=F16-J16-(G3*106) |
|
E17 |
=B17/220*E4 |
L17 |
=G17*0,06 |
B28 |
=F17-J17-(G4*106) |
|
E18 |
=B18/220*E5 |
L18 |
=G18*0,06 |
B29 |
=F18-J18-(G5*106) |
|
E19 |
=B19/220*E6 |
L19 |
=G19*0,06 |
B30 |
=F19-J19-(G6*106) |
|
E20 |
=B20/220*E7 |
L20 |
=G20*0,06 |
B31 |
=F20-J20-(G7*106) |
|
E21 |
=B21/220*E8 |
L21 |
=G21*0,06 |
B32 |
=F21-J21-(G8*106) |
|
E22 |
=B22/220*E9 |
L22 |
=G22*0,06 |
B33 |
=F22-J22-(G9*106) |
|
E23 |
=B23/220*E10 |
L23 |
=G23*0,06 |
B34 |
=F23-J23-(G10*106) |
|
E25 |
=SOMA(E16:E24) |
L25 |
=SOMA(L16:L24) |
|
|
|
J17 Sal.Fam. |
=SE(G17<=840,47;G17*0,0765;SE(E(G17>840,48;G17<=1050);(G17*0,0865);SE(E(G17>1050,01;G17<=1400,77);(G17*0,09);SE(E(G17>1400,78;G17<=2801,56);(G17*0,11);SE(E(G17>2801,56);"R$ 308,17"))))) |
|
J18 |
=SE(G18<=840,47;G18*0,0765;SE(E(G18>840,48;G18<=1050);(G18*0,0865);SE(E(G18>1050,01;G18<=1400,77);(G18*0,09);SE(E(G18>1400,78;G18<=2801,56);(G18*0,11);SE(E(G18>2801,56);"R$ 308,17"))))) |
|
J19 |
=SE(G19<=840,47;G19*0,0765;SE(E(G19>840,48;G19<=1050);(G19*0,0865);SE(E(G19>1050,01;G19<=1400,77);(G19*0,09);SE(E(G19>1400,78;G19<=2801,56);(G19*0,11);SE(E(G19>2801,56);"R$ 308,17"))))) |
|
J20 |
=SE(G20<=840,47;G20*0,0765;SE(E(G20>840,48;G20<=1050);(G20*0,0865);SE(E(G20>1050,01;G20<=1400,77);(G20*0,09);SE(E(G20>1400,78;G20<=2801,56);(G20*0,11);SE(E(G20>2801,56);"R$ 308,17"))))) |
|
J21 |
=SE(G21<=840,47;G21*0,0765;SE(E(G21>840,48;G21<=1050);(G21*0,0865);SE(E(G21>1050,01;G21<=1400,77);(G21*0,09);SE(E(G21>1400,78;G21<=2801,56);(G21*0,11);SE(E(G21>2801,56);"R$ 308,17"))))) |
|
J22 |
=SE(G22<=840,47;G22*0,0765;SE(E(G22>840,48;G22<=1050);(G22*0,0865);SE(E(G22>1050,01;G22<=1400,77);(G22*0,09);SE(E(G22>1400,78;G22<=2801,56);(G22*0,11);SE(E(G22>2801,56);"R$ 308,17"))))) |
|
J23 |
=SE(G23<=840,47;G23*0,0765;SE(E(G23>840,48;G23<=1050);(G23*0,0865);SE(E(G23>1050,01;G23<=1400,77);(G23*0,09);SE(E(G23>1400,78;G23<=2801,56);(G23*0,11);SE(E(G23>2801,56);"R$ 308,17"))))) |
|
J24 |
=SE(G24<=840,47;G24*0,0765;SE(E(G24>840,48;G24<=1050);(G24*0,0865);SE(E(G24>1050,01;G24<=1400,77);(G24*0,09);SE(E(G24>1400,78;G24<=2801,56);(G24*0,11);SE(E(G24>2801,56);"R$ 308,17"))))) |
|
J25 |
=SOMA(J16:J24) |
|
L17 IRRF |
=SE(C27<=1257,12;"R$
0,00";SE(E(C27>1257,13;C27<=2512,08);(C27*0,15-188,57);SE(C27>2512,08;C27*0,275-502,58))) |
|
L18 |
=SE(C28<=1257,12;"R$
0,00";SE(E(C28>1257,13;C28<=2512,08);(C28*0,15-188,57);SE(C28>2512,08;C28*0,275-502,58))) |
|
L19 |
=SE(C29<=1257,12;"R$ 0,00";SE(E(C29>1257,13;C29<=2512,08);(C29*0,15-188,57);SE(C29>2512,08;C29*0,275-502,58))) |
|
L20 |
=SE(C30<=1257,12;"R$
0,00";SE(E(C30>1257,13;C30<=2512,08);(C30*0,15-188,57);SE(C30>2512,08;C30*0,275-502,58))) |
|
L21 |
=SE(C31<=1257,12;"R$ 0,00";SE(E(C31>1257,13;C31<=2512,08);(C31*0,15-188,57);SE(C31>2512,08;C31*0,275-502,58))) |
|
L22 |
=SE(C32<=1257,12;"R$
0,00";SE(E(C32>1257,13;C32<=2512,08);(C32*0,15-188,57);SE(C32>2512,08;C32*0,275-502,58))) |
|
L23 |
=SE(C33<=1257,12;"R$ 0,00";SE(E(C33>1257,13;C33<=2512,08);(C33*0,15-188,57);SE(C33>2512,08;C33*0,275-502,58))) |
|
L24 |
=SE(C34<=1257,12;"R$
0,00";SE(E(C34>1257,13;C34<=2512,08);(C34*0,15-188,57);SE(C34>2512,08;C34*0,275-502,58))) |
|
L26 |
=SOMA(K17:K24) |
|
K17 INSS |
=SE(F16<=435,52;F3*22,33;SE(E(F16>435,52;F16<=654,61);(F3*15,74);SE(E(F16>654,61);"R$ 0,00"))) |
|
K18 |
=SE(F17<=435,52;F4*22,33;SE(E(F17>435,52;F17<=654,61);(F4*15,74);SE(E(F17>654,61);"R$ 0,00"))) |
|
K19 |
=SE(F18<=435,52;F5*22,33;SE(E(F18>435,52;F18<=654,61);(F5*15,74);SE(E(F18>654,61);"R$ 0,00"))) |
|
K20 |
=SE(F19<=435,52;F6*22,33;SE(E(F19>435,52;F19<=654,61);(F6*15,74);SE(E(F19>654,61);"R$ 0,00"))) |
|
K21 |
=SE(F20<=435,52;F7*22,33;SE(E(F20>435,52;F20<=654,61);(F7*15,74);SE(E(F20>654,61);"R$ 0,00"))) |
|
K22 |
=SE(F21<=435,52;F8*22,33;SE(E(F21>435,52;F21<=654,61);(F8*15,74);SE(E(F21>654,61);"R$ 0,00"))) |
|
K23 |
=SE(F22<=435,52;F9*22,33;SE(E(F22>435,52;F22<=654,61);(F9*15,74);SE(E(F22>654,61);"R$ 0,00"))) |
|
K24 |
=SE(F23<=435,52;F10*22,33;SE(E(F23>435,52;F23<=654,61);(F10*15,74);SE(E(F23>654,61);"R$ 0,00"))) |