Palgaarvestuse näide (0)

Overview

valemid
Funktsiooni väärtuste arvutami
IF funktsioon
maksud
ulesanne iseseisvaks lahendami

Sheet 1: valemid

a b c x y 6 2 -4 3 5

Suurus Exceli valem Valem
D -3 D=
E -0.75
F 1.2857142857
G 0.9
H 2.5446900494
I 5.8309518948
J 3.2396118013
K 2.0622769172
L 2.3406402454
M 1.004338815
N -1.2104606168 N=sin2x+cos(x*x)- sinx *sin x

Sheet 2: Funktsiooni väärtuste arvutami

samm 0.5
x y z
5 -0.517714001 1.3667174655
5.5 -0.7724854321 -0.8154107552
6 -1.0306732064 -1.586463587
6.5 -1.2927744846 -0.4014628156
7 -1.5586930536 1.7228312903
7.5 -1.8282907827 3.1929679215
8 -2.1014099742 2.0827836539
8.5 -2.3778861364 -0.6166870565
9 -2.657555335 0.1955403811
9.5 -2.9402583675 -1.2069042873
10 -3.2258430349 1.0712230921
Arv e Exp()

Arv π Pi()

Absoluutväärtus Abs()

Sheet 3: IF funktsioon

x y z
-5 -1.5172145872 5.5
-4 0.5634998986 4.6
-3 3.88051086 3.9
-2 -0.9609308626 -9
-1 -0.2484405096 -7
0 4 -5
1 -1.2943999597 -3
2 -3.397077491 -1
3 0.0605924262 -0.8382464946
4 -4.68286459 2.9680747399

5 1.2514392008 -1.6320633327

Sheet 4: maksud

Palk kroonides Töötukindlustus maks Kogumispensioon Tulumaks sots.maks Arvele
Maksuvaba minimum 2250
10920 305.76 218.4 1710.6264 3603.6 8685.2136
Töötukindlustus maks 2.80%
10980 307.44 219.6 1722 .6216 3623.4 8730.3384
Kogumispensioon 2%
11640 325.92 232.8 1854.5688 3841.2 9226.7112
Tulumaks 21%
14100 394.8 282 2346.372 4653 11076.828
Sots. Maks 33%
14100 394.8 282 2346.372 4653 11076.828
16080 450.24 321.6 2742.2136 5306.4 12565. 9464
16080 450.24 321.6 2742.2136 5306.4 12565.9464
16080 450.24 321.6 2742.2136 5306.4 12565.9464
16140 451.92 322.8 2754.2088 5326.2 12611.0712
16140 451.92 322.8 2754.2088 5326.2 12611.0712
16320 456.96 326.4 2790.1944 5385.6 12746.4456
16320 456.96 326.4 2790.1944 5385.6 12746.4456
19600 548.8 392 3445.932 6468 15213.268
20220 566.16 404.4 3569.8824 6672.6 15679.5576
20400 571.2 408 3605.868 6732 15814.932
21060 589.68 421.2 3737.8152 6949.8 16311.3048
21600 604.8 432 3845.772 7128 16717.428
26750 749 535 4875.36 8827.5 20590.64
7260 203.28 145.2 978.9192 2395.8 5932.6008
9600 268.8 192 1446.732 3168 7692.468
9660 270.48 193.2 1458 .7272 3187.8 7737.5928
9660 270.48 193.2 1458.7272 3187.8 7737.5928
9720 272.16 194.4 1470.7224 3207.6 7782.7176
9780 273.84 195.6 1482 .7176 3227.4 7827.8424
9780 273.84 195.6 1482.7176 3227.4 7827.8424
2200 61.6 44 0 726 2094.4
2500 70 50 27.3 825 2352.7

Sheet 5: ulesanne iseseisvaks lahendami

x y z a b
35° 55° 1 2.5 -1.5

Suurus Exceli valem Valem
K
L
M