top of page
Centre of Power
Home
Centre of Power
MS Excel
MS Excel: functions
MS Excel: shortcuts
About
MS Excel functions
MS Excel functions
MS Excel functions
MS Excel functions
Mostly used functions
AND
AVERAGE
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
DATEIF
IF
IFERROR
IFS
INDEX
LEFT
RIGHT
MID
OR
MAX
MIN
Hacks
Symbolic operators
Financial functions
Financial functions
Financial functions
Financial functions
Functions
ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DURATION
EFFECT
FV
FVSCHEDULE
INTRATE
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PDURATION
PMT
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
PV
RATE
RECEIVED
RRI
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
XIRR
YIELDDISC
YIELDMAT
YIELD
Logical functions
Logical functions
Logical functions
Logical functions
Functions
AND
FALSE
IF
IFS
IFERROR
IFNA
NOT
OR
SWITCH
TRUE
XOR
TEXT functions
TEXT functions
TEXT functions
TEXT functions
Functions
ARRAYTOTEXT
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LET
LOWER
MID
NUMBERVALUE
PROPER
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
T
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER
VALUE
VALUETOTEXT
Date functions
Date functions
Date functions
Date functions
Functions
DATE
DATEVALUE
DAY
DAYS
DAYS360
EDATE
HOUR
ISOWEEKNUM
MINUTE
MONTH
NETWORKDAYS
NETWORKDAYS.INTL
NOW
NOW
SECOND
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC
bottom of page
