Scribd
Upload
5 views2 pages

Excel Advanced Formulas

The document provides a comprehensive list of Excel functions categorized into Lookup & Reference, Logical Functions, Text Functions, Date & Time, Math & Statistical, and Advanced Dynamic Arrays. Each category includes specific functions along with their syntax for use. This serves as a quick reference guide for users to utilize various Excel functions effectively.

Uploaded by

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

Excel Advanced Formulas

The document provides a comprehensive list of Excel functions categorized into Lookup & Reference, Logical Functions, Text Functions, Date & Time, Math & Statistical, and Advanced Dynamic Arrays. Each category includes specific functions along with their syntax for use. This serves as a quick reference guide for users to utilize various Excel functions effectively.

Uploaded by

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

Lookup & Reference

VLOOKUP: =VLOOKUP(value, table, col_index, FALSE)


HLOOKUP: =HLOOKUP(value, table, row_index, FALSE)
XLOOKUP: =XLOOKUP(lookup_value, lookup_array, return_array)
INDEX MATCH: =INDEX(return_range, MATCH(value, lookup_range, 0))

Logical Functions

IF: =IF(condition, value_if_true, value_if_false)


IFS: =IFS(condition1, result1, condition2, result2)
AND: =AND(cond1, cond2)
OR: =OR(cond1, cond2)

Text Functions

LEFT: =LEFT(text, num_chars)


RIGHT: =RIGHT(text, num_chars)
MID: =MID(text, start, length)
LEN: =LEN(text)
CONCAT: =CONCAT(text1, text2)
TEXTJOIN: =TEXTJOIN(delimiter, TRUE, range)

Date & Time

TODAY: =TODAY()
NOW: =NOW()
DATEDIF: =DATEDIF(start, end, "Y")
EOMONTH: =EOMONTH(start_date, months)

Math & Statistical

SUM: =SUM(range)
SUMIF: =SUMIF(range, criteria, sum_range)
SUMIFS: =SUMIFS(sum_range, criteria_range1, criteria1)
COUNT: =COUNT(range)
COUNTIF: =COUNTIF(range, criteria)
AVERAGE: =AVERAGE(range)

Advanced Dynamic Arrays

FILTER: =FILTER(range, condition)


SORT: =SORT(range)
UNIQUE: =UNIQUE(range)
SEQUENCE: =SEQUENCE(rows, columns)

You might also like