Functii Excel
2
FUNCTII STATISTICE: MAX(N1;N2) MIN(N1;N2,…) SUM(N1;N2;…) PRODUCT(N1;N2…) AVERAGE(N1;N2;…) COUTN(N1;N2) FUNCTII PENTRU DATA CALENDARISTICA SI ORA: TODAY()-DATA CURENTA YEAR(n),month(n),day(n)-ANUL CE CORESPUNDE UNUI NUMAR (YEAR(1)=1990) NOW()-DATA SI ORA SISTEMULUI TIME(ORA;M;S) CONVERSIA CELOR 3 VALORI NUMERICE LA ORA(TIME(12;34;9)= 2:34:09 FUNCTII NUMERICE INT (N)-PARTEA INTREAGA A NR DAT CA PARAM ROUND(N;Z)-ROTUNJIRE LA A z-A cifra zecimala matematica in plus sau in minus( ROUND(123.24,0)=123, ROUND(123,56,0)=124 ROUNDDOWN(N;Z) ROUNDUP(N;Z) EXP(NR)=VALOAREA ABSOLUTA (EXP(-3)=3)
description
Functii Excel
Transcript of Functii Excel
FUNCTII STATISTICE:
MAX(N1;N2)
MIN(N1;N2,…)
SUM(N1;N2;…)
PRODUCT(N1;N2…)
AVERAGE(N1;N2;…)
COUTN(N1;N2)
FUNCTII PENTRU DATA CALENDARISTICA SI ORA:
TODAY()-DATA CURENTA
YEAR(n),month(n),day(n)-ANUL CE CORESPUNDE UNUI NUMAR (YEAR(1)=1990)
NOW()-DATA SI ORA SISTEMULUI
TIME(ORA;M;S) CONVERSIA CELOR 3 VALORI NUMERICE LA ORA(TIME(12;34;9)=
2:34:09
FUNCTII NUMERICE
INT (N)-PARTEA INTREAGA A NR DAT CA PARAM
ROUND(N;Z)-ROTUNJIRE LA A z-A cifra zecimala matematica in plus sau in minus( ROUND(123.24,0)=123, ROUND(123,56,0)=124
ROUNDDOWN(N;Z)
ROUNDUP(N;Z)
EXP(NR)=VALOAREA ABSOLUTA (EXP(-3)=3)
MOD(N1;N2) RESTUL IMPARATIRII INTREGI A LUI N1 LA N2(MOD(5;2)=1)
RAND()-GENERAREA UNUI NR ALEATOR INTRE 0 SI 1)