Scribd
Upload
13 views

Advanced Excel Formulas

Uploaded by

excellearning80
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
13 views

Advanced Excel Formulas

Uploaded by

excellearning80
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Category Formula

Syntax/Description
Lookup andVLOOKUP 0
Lookup andHLOOKUP 0
Lookup andINDEX 0
Lookup andMATCH 0
Lookup andXLOOKUP #NAME?
Lookup andOFFSET #NAME?
Logical IF 0
Logical IFS Err:508
Logical AND Err:508
Logical OR Err:508
Logical NOT 0
Text CONCATEN Err:508
Text TEXTJOIN Err:508
Text LEFT 0
Text RIGHT 0
Text MID 0
Text TRIM 0
Text LEN 0
Text FIND 0
Text SUBSTITUT 0
Math SUMIF 0
Math SUMPRODU Err:508
Math ROUND 0
Math ROUNDUP 0
Math ROUNDDO 0
Math MOD 0
Math CEILING 0
Math FLOOR 0
Math RAND 0.203979
Math RANDBETW #NAME?
Date and TTODAY 12/14/24
Date and TNOW ###
Date and TDATE 0
Date and TDATEDIF 0
Date and TEDATE 0
Date and TNETWORKD 0
Array UNIQUE #NAME?
Array SORT #NAME?
Array FILTER #NAME?
Array SEQUENCE #NAME?
Error HandIFERROR 0
Error HandIFNA 0
Error HandERROR.TYP 0
Statistical AVERAGEIF 0
Statistical COUNTIF 0
Statistical LARGE 0
Statistical SMALL 0
Financial PMT 0
Financial NPV Err:508
Financial IRR 0

You might also like