KEMBAR78
Must-Know Excel Formulas | PDF
Scribd
Upload
35 views6 pages

Must-Know Excel Formulas

The document provides a list of Excel formulas along with their purposes. It covers various categories such as mathematical functions, text manipulation, date functions, and data analysis. Each formula is briefly described to explain its functionality.

Uploaded by

babinphoto05
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
35 views6 pages

Must-Know Excel Formulas

The document provides a list of Excel formulas along with their purposes. It covers various categories such as mathematical functions, text manipulation, date functions, and data analysis. Each formula is briefly described to explain its functionality.

Uploaded by

babinphoto05
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/ 6

Formula Purpose

SUM(A1:A1Adds all numbers in the range


AVERAGE(AReturns the average
IF(A1>10, "Logical test with condition
AND(A1>0,Returns TRUE if all conditions are TRUE
OR(A1>0, Returns TRUE if any condition is TRUE
NOT(A1=10Reverses a logical value
Formula Purpose
VLOOKUP(vaVertical lookup
HLOOKUP(vaHorizontal lookup
INDEX(arraGets a value from a specific position
MATCH(valuReturns the position of a value
OFFSET(refe
Returns a reference offset from a cell
Formula Purpose
CONCATENA Joins text from multiple cells
TEXTJOIN("Joins text with a delimiter
LEFT(A1, 4)Extracts first 4 characters
RIGHT(A1, Extracts last 3 characters
MID(A1, 3, Extracts 2 characters from 3rd position
LEN(A1) Counts number of characters
TRIM(A1) Removes extra spaces
UPPER/LOW Changes text case
Formula Purpose
TODAY() Current date
NOW() Current date and time
DATEDIF(stDays/months/years between dates
EDATE(A1, Adds 3 months to a date
TEXT(A1, Formats a date as text
Formula Purpose
COUNT(A1:Counts numbers
COUNTA(A1 Counts non-empty cells
COUNTIF(A1Counts cells matching condition
SUMIF(rangSums with a condition
AVERAGEIF(Averages with a condition
Formula Purpose
UNIQUE(raReturns unique values
FILTER(rangFilters data based on criteria
SORT(rangeSorts values
SEQUENCE(roGenerates sequential numbers

You might also like