تبلیغات
EXCEL - لیست کل توابع اکسل 2003
EXCEL
آشنایی با نرم افزار گمنام ولی جادویی اکسل

A:

ABS 

ACOS

ACOSH 

ADRRESS

AND

AREAS

ASIN

ASINH

ATAN 

ATAN2

ATANH

AVEDEV

AVERAGE

AVERAGEA

B:

BAHTTEXT

BETADIST

BETAINV

BINOMDIST

C:

CEILING

CELL

CHAR

CHIDIST

CHIINV

CHINTEST

CHOOSE

 

CLEAN

CODE

COLUMN

COLUMNS

COMBIN

CONCATENATE

CONFIDENCE

CORREL

COS 

COSH

COUNT 

COUNTA

COUNTBLANK

COUNTIF

COVAR

CRITBINOM

D:

DATE

DATEVALUE

DAVERAGE

DAY

DAYS360

DB

DCOUNT

DCOUNTA

DDB

DEGREES

DEVSQ

DGET

DMAX

DMIN

DOLLAR

DPROUDUCT

DSTDEV

DSTDEVP

DSUM

DVAR

DVARP

E:

ERROR.TYPE

EVEN

EXACT

EXP

EXPONDIST

F:

FACT

FALSE 

FDIST

FIND

FINV

FISHER

FISHERINV

FIXED

FLOOR

FORECAST

FREQUENCY

FTEST

FV

G:

GAMMADIST

GAMMAINV

GAMMALN

GEOMIN

GETPIVOTDATA

GROWTH

H:

HARMEAN

HLOOKUP

HOUR

HYPERLINK

HYPERGEOMDIST

I:


IF

INDEX

INDIRECT

INFO

INT

INTERCEPT

IPMT

IRR

ISBLANK

ISERROR

ISERR

ISLOGICAL

ISPMT

ISREF

ISTEXT

J:

K:

KURT

L:

LARGE

LEFT

LEN

LINEST

LN

LOG

LOG10

LOGEST

LOGINV

LOGNORMDIST

LOOKUP

LOWER


M:

MATCH

MAX

MAXA

MDETERM

MEDIAN

MID

MIN

MINA

MINUTE

MINVERSE

MIRR

MMULT

MODE

MONTH

N:

N

NA

NEGBINOMIST

NORMDIST

NORMINV

NORMSDIST

NORMSINV

NOT

NOW

NPER

NPV

O:

ODD

OFFSET

OR

PEARSON

PERCENTILE

PERCENTRANK

PERMUT

PI

PMT

POISSON

POWER

PPMT

PROB

PRODUCT

PROPER

PV

Q:

QUARTILE

R:

RADIANS

RAND

RANK

RATE

REPLACE

REPT

RIGHT

ROMAN

ROUND

ROUNDDOWN

ROUNDUP

ROW

ROWS

RSQ

RTD

S:

SEARCH

SECOND

SIGN

SIN 

SINH

SKEW

SLN

SLOPE

SMALL

SQRT

STANDARDISE

STDEV

STDEVA

STDEVP

STDEVPA

STEYX

SUBSTITUTE

SUBTOTAL

SUM

SUMIF

SUMPRODUCT

SUMSQ

SUMX2MY2

SUMX2PY2

SUMX2MY2

SYP

T:

T

TAN

TANH

TDIST

TEXT

TIME

TIMEVALUE

TINV

TODAY

TRANSPOSE

TREND

TRIM

TRIMMEAN

TRUE

TRUNC

TTEST

TYPE

U:

UPPER

V:

VALUE

VAR

VARA

VARP

VARPA

VDB

VLOOKUP

W:

WEEKDAY

WEIBULL

X:

Y:

YEAR

Z:

ZTEST