Scribd
Upload
147 views2 pages

Excel Formulas Notes

The document provides a comprehensive overview of essential Excel formulas categorized into Basic Formulas, Lookup & Reference, Text Functions, Date & Time, Math & Logic, and Advanced/Dynamic Arrays. Each category includes specific functions with their syntax and brief descriptions. This serves as a quick reference guide for users to efficiently utilize Excel's capabilities.

Uploaded by

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

Excel Formulas Notes

The document provides a comprehensive overview of essential Excel formulas categorized into Basic Formulas, Lookup & Reference, Text Functions, Date & Time, Math & Logic, and Advanced/Dynamic Arrays. Each category includes specific functions with their syntax and brief descriptions. This serves as a quick reference guide for users to efficiently utilize Excel's capabilities.

Uploaded by

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

Excel Formulas & Notes

Basic Formulas
SUM: Adds numbers =SUM(A1:A10)

AVERAGE: Calculates average =AVERAGE(A1:A10)

MIN / MAX: Finds smallest/largest value =MIN(A1:A10), =MAX(A1:A10)

IF: Conditional logic =IF(A1>10, "Yes", "No")

COUNT / COUNTA: Counts numbers/text =COUNT(A1:A10), =COUNTA(A1:A10)

COUNTIF / COUNTIFS: Counts with condition(s) =COUNTIF(A1:A10,">5")

Lookup & Reference


VLOOKUP: Vertical lookup =VLOOKUP(lookup_value, table_array, col_index, FALSE)

HLOOKUP: Horizontal lookup

INDEX: Returns value from table =INDEX(A1:C10,2,3)

MATCH: Position of value =MATCH(50,A1:A10,0)

XLOOKUP: Flexible lookup =XLOOKUP(lookup,lookup_array,return_array)

Text Functions
CONCAT / CONCATENATE: Joins text =CONCAT(A1, " ", B1)

LEFT / RIGHT: Extracts text =LEFT(A1,5), =RIGHT(A1,3)

MID: Extracts substring =MID(A1,2,4)

LEN: Counts characters =LEN(A1)

TRIM: Removes extra spaces =TRIM(A1)

PROPER / UPPER / LOWER: Changes case =UPPER(A1), =LOWER(A1)

Date & Time


TODAY: Current date =TODAY()

NOW: Current date & time =NOW()


DAY / MONTH / YEAR: Extracts date parts

EDATE: Adds months to a date =EDATE(A1,3)

NETWORKDAYS: Working days between dates =NETWORKDAYS(A1,B1)

Math & Logic


ROUND / ROUNDUP / ROUNDDOWN: Rounds numbers

ABS: Absolute value =ABS(A1)

SQRT: Square root =SQRT(A1)

POWER: Exponential =POWER(A1,2)

MOD: Remainder =MOD(A1,3)

AND / OR / NOT: Logical operators =AND(A1>0,B1<10)

Advanced / Dynamic Arrays


FILTER: Filter range =FILTER(A1:B10, B1:B10>50)

SORT: Sort values =SORT(A1:A10)

UNIQUE: Unique values =UNIQUE(A1:A10)

SEQUENCE: Generates numbers =SEQUENCE(10,1,1,1)

XMATCH: Improved MATCH =XMATCH(lookup,array)

You might also like