All Excel Formulas

Financial formulas

 
ACCRINT formula NOMINAL formula
ACCRINTM formula NPER formula
AMORDEGRC formula NPV formula
AMORLINC formula ODDFPRICE formula
COUPDAYBS formula ODDFYIELD formula
COUPDAYS formula ODDLPRICE formula
COUPDAYSNC formula ODDLYIELD formula
COUPNCD formula PMT formula
COUPNUM formula PPMT formula
COUPPCD formula PRICE formula
CUMIPMT formula PRICEDISC formula
CUMPRINC formula PRICEMAT formula
DB formula PV formula
DDB formula RATE formula
DISC formula RECEIVED formula
DOLLARDE formula SLN formula
DOLLARFR formula SYD formula
DURATION formula TBILLEQ formula
EFFECT formula TBILLPRICE formula
FV formula TBILLYIELD formula
FVSCHEDULE formula VDB formula
INTRATE formula XIRR formula
IPMT formula XNPV formula
IRR formula YIELD formula
ISPMT formula YIELDDISC formula
MDURATION formula YIELDMAT formula
MIRR formula  
   
   

Logical formulas

 
AND formula NOT formula
FALSE formula OR formula
IF formula TRUE formula
   
   
   

Text formulas

 
ASC formula MID, MIDB formulas
BAHTTEXT formula PHONETIC formula
CHAR formula PROPER formula
CLEAN formula REPLACE, REPLACEB formulas
CODE formula REPT formula
CONCATENATE formula RIGHT, RIGHTB formulas
DOLLAR formula SEARCH, SEARCHB formulas
EXACT formula SUBSTITUTE formula
FIND, FINDB formulas T formula
FIXED formula TEXT formula
JIS formula TRIM formula
LEFT, LEFTB formulas UPPER formula
LEN, LENB formulas VALUE formula
LOWER formula  
   
   

Date and Time formulas

 
DATE formula NOW formula
DATEVALUE formula SECOND formula
DAY formula TIME formula
DAYS360 formula TIMEVALUE formula
EDATE formula TODAY formula
EOMONTH formula WEEKDAY formula
HOUR formula WEEKNUM formula
MINUTE formula WORKDAY formula
MONTH formula WORKDAY.INTL formula
NETWORKDAYS formula YEAR formula
NETWORKDAYS.INTL formula YEARFRAC formula
   
   

Lookup and Reference formulas

 
ADDRESS formula INDIRECT formula
AREAS formula LOOKUP formula
CHOOSE formula MATCH formula
COLUMN formula OFFSET formula
COLUMNS formula ROW formula
GETPIVOTDATA formula ROWS formula
HLOOKUP formula RTD formula
HYPERLINK formula TRANSPOSE formula
INDEX formula VLOOKUP formula
   
   

Math and Trigonometry formulas

 
ABS formula MROUND formula
ACOS formula MULTINOMIAL formula
ACOSH formula ODD formula
AGGREGATE formula PI formula
ASIN formula POWER formula
ASINH formula PRODUCT formula
ATAN formula QUOTIENT formula
ATAN2 formula RADIANS formula
ATANH formula RAND formula
CEILING formula RANDBETWEEN formula
CEILING.PRECISE formula ROMAN formula
COMBIN formula ROUND formula
COS formula ROUNDDOWN formula
COSH formula ROUNDUP formula
DEGREES formula SERIESSUM formula
EVEN formula SIGN formula
EXP formula SIN formula
FACT formula SINH formula
FACTDOUBLE formula SQRT formula
FLOOR formula SQRTPI formula
FLOOR.PRECISE formula SUBTOTAL formula
GCD formula SUM formula
INT formula SUMIF formula
ISO.CEILING formula SUMIFS formula
LCM formula SUMPRODUCT formula
LN formula SUMSQ formula
LOG formula SUMX2MY2 formula
LOG10 formula SUMX2PY2 formula
MDETERM formula SUMXMY2 formula
MINVERSE formula TAN formula
MMULT formula TANH formula
MOD formula TRUNC formula