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 СРЗНАЧ (yoki
AVERAGE) () - barcha argumentlar
qiymatining o‘rta arifmetigini hisoblaydi. Masalan:
=СРЗНАЧ(A5:A50) - A5
62
yacheykadan A50 gacha bo‘lgan yacheykalardagi sonli qiymatlarning o‘rta
arifmetigini hisoblaydi.
MAKС( yoki
MAX ) () - argumentlar ro‘yxatidan eng
kattasi(maksimal son)ni topadi. Masalan,