Scribd
Upload
102 views3 pages

Excel Formulas Guide

The document provides a comprehensive overview of various Excel formulas categorized into sections such as Basic Arithmetic, Logical Functions, Lookup and Reference, Text Functions, Date and Time, Financial Functions, Statistical Functions, and Advanced Functions. Each section includes examples of commonly used formulas to perform specific tasks in Excel. This serves as a useful reference for users looking to enhance their Excel skills.

Uploaded by

Deepanshu Chaudhary
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
102 views3 pages

Excel Formulas Guide

The document provides a comprehensive overview of various Excel formulas categorized into sections such as Basic Arithmetic, Logical Functions, Lookup and Reference, Text Functions, Date and Time, Financial Functions, Statistical Functions, and Advanced Functions. Each section includes examples of commonly used formulas to perform specific tasks in Excel. This serves as a useful reference for users looking to enhance their Excel skills.

Uploaded by

Deepanshu Chaudhary
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
You are on page 1/ 3

Excel Formulas with Examples

1. Basic Arithmetic and Aggregation Functions

Arithmetic Operators:

- Addition (+): =A1 + B1

- Subtraction (-): =A1 - B1

- Multiplication (*): =A1 * B1

- Division (/): =A1 / B1

- Exponent (^): =A1 ^ 2

SUM: =SUM(A1:A5)

AVERAGE: =AVERAGE(B1:B10)

MIN: =MIN(C1:C10)

MAX: =MAX(C1:C10)

COUNT: =COUNT(A1:A10)

COUNTA: =COUNTA(A1:A10)

2. Logical Functions

IF: =IF(A1>10, "Greater than 10", "10 or less")

Nested IF: =IF(A1>10, "Above 10", IF(A1<5, "Below 5", "Between 5 and 10"))

IFS: =IFS(A1>10, "Above 10", A1>5, "Between 6 and 10", TRUE, "5 or below")

AND: =AND(A1>0, B1>0)

OR: =OR(A1>0, B1>0)

NOT: =NOT(A1=0)

IFERROR: =IFERROR(A1/B1, "Error in calculation")

3. Lookup and Reference Functions


Excel Formulas with Examples
VLOOKUP: =VLOOKUP("Apple", A2:C10, 3, FALSE)

HLOOKUP: =HLOOKUP("January", A1:Z3, 2, FALSE)

INDEX & MATCH: =INDEX(C1:C10, MATCH("Apple", A1:A10, 0))

XLOOKUP: =XLOOKUP("Apple", A2:A10, B2:B10, "Not Found")

OFFSET: =SUM(OFFSET(A1, 2, 0, 3, 1))

4. Text Functions

CONCATENATE: =CONCATENATE("Hello", " ", "World")

TEXTJOIN: =TEXTJOIN(" ", TRUE, A1, B1, C1)

LEFT: =LEFT("Excel", 2)

RIGHT: =RIGHT("Excel", 2)

MID: =MID("Excel", 2, 3)

LEN: =LEN("Hello")

SEARCH: =SEARCH("l", "Hello")

FIND: =FIND("l", "Hello")

UPPER: =UPPER("Excel")

LOWER: =LOWER("Excel")

PROPER: =PROPER("excel functions")

5. Date and Time Functions

TODAY: =TODAY()

NOW: =NOW()

DATE: =DATE(2025, 4, 10)

DAY: =DAY(A1)

MONTH: =MONTH(A1)

YEAR: =YEAR(A1)

DATEDIF: =DATEDIF(A1, B1, "d")


Excel Formulas with Examples
NETWORKDAYS: =NETWORKDAYS(A1, B1, C1:C5)

6. Financial Functions

PMT: =PMT(0.05/12, 60, 10000)

FV: =FV(0.05/12, 60, -200, -10000)

PV: =PV(0.05/12, 60, -200, 0)

RATE: =RATE(60, -200, 10000)

NPER: =NPER(0.05/12, -200, 10000)

7. Statistical Functions

MEDIAN: =MEDIAN(A1:A10)

MODE: =MODE(A1:A10)

STDEV.S: =STDEV.S(A1:A10)

VAR.S: =VAR.S(A1:A10)

COUNTIF: =COUNTIF(A1:A10, ">10")

SUMIF: =SUMIF(B1:B10, "Apple", C1:C10)

AVERAGEIF: =AVERAGEIF(B1:B10, "Apple", C1:C10)

8. Advanced and Array Functions

Array Formula (Ctrl+Shift+Enter): {=SUM(A1:A10*B1:B10)}

TRANSPOSE: =TRANSPOSE(A1:C3)

FILTER: =FILTER(A1:C10, B1:B10="Apple")

UNIQUE: =UNIQUE(A1:A10)

SORT: =SORT(A1:A10)

LET: =LET(x, SUM(A1:A10), x/COUNT(A1:A10))

You might also like