ABS(son)
- sonning modulini hisoblaydi;
LN (son)
- sonning natural logarifmini hisoblaydi;
EXP (son)
- sonning eksponentasini hisoblaydi;
SIN (son
) - sonning sinusini hisoblaydi;
COS (son)
- sonning kosinusini hisoblaydi;
TAN (son)
- sonning tangensini hisoblaydi (radianda).
Statistik funksiyalar
SRZNACh
(yoki
AVERAGE)
() - barcha argumentlar
qiymatining o‘rta arifmetigini hisoblaydi. Masalan:
=SRZNACh(A5:A50)
- A5
yacheykadan A50 gacha bo‘lgan yacheykalardagi sonli qiymatlarning o‘rta
arifmetigini hisoblaydi.
MAKS(
yoki
MAX
) () - argumentlar ro‘yxatidan eng
kattasi(maksimal son)ni topadi. Masalan,
=MAKS(H10:H25) -
H10 yacheykadan
H25 yacheykagacha bo‘lgan sonlardan eng kattasini topadi.
67
Do'stlaringiz bilan baham: |