Scribd
Upload
2 views2 pages

Excel Formula Guide with Examples

This document is an Excel Formula Guide that provides categorized formulas with examples for various functions including mathematical, statistical, text, logical, lookup, date & time, and dynamic array functions. Each section contains formulas, examples, and their corresponding results, making it a practical resource for users. The guide features a clean layout and modern formatting for easy readability.

Uploaded by

farazniazi746
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
2 views2 pages

Excel Formula Guide with Examples

This document is an Excel Formula Guide that provides categorized formulas with examples for various functions including mathematical, statistical, text, logical, lookup, date & time, and dynamic array functions. Each section contains formulas, examples, and their corresponding results, making it a practical resource for users. The guide features a clean layout and modern formatting for easy readability.

Uploaded by

farazniazi746
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

Excel Formula Guide with Examples

This upgraded PDF includes categorized formulas with clean layout, modern formatting, and
easy-to-read examples.

1. Mathematical Functions
Formula Example Result
SUM() =SUM(10, 20, 30) 60
PRODUCT() =PRODUCT(5, 4) 20
ROUND() =ROUND(3.14159, 2) 3.14
INT() =INT(7.89) 7
MOD() =MOD(10, 3) 1

2. Statistical Functions
Formula Example Result
AVERAGE() =AVERAGE(10,20,30) 20
COUNT() =COUNT(A1:A10)
COUNTIF() =COUNTIF(A1:A10, "Yes")
MAX() =MAX(10,50,3) 50
MIN() =MIN(10,50,3) 3

3. Text Functions
Formula Example Result
LEFT() =LEFT("Excel",2) Ex
RIGHT() =RIGHT("Excel",3) cel
MID() =MID("Excel",2,3) xce
LEN() =LEN("Hello") 5
PROPER() =PROPER("my name is awais") My Name Is Awais

4. Logical Functions
Formula Example Result
IF() =IF(A1>50,"Pass","Fail")
IFERROR() =IFERROR(A1/B1, "Error")
AND() =AND(A1>10, B1<5)
OR() =OR(A1=10, A1=20)

5. Lookup Functions
Formula Example Result
VLOOKUP() =VLOOKUP("Awais", A2:C10, 3, FALSE)
XLOOKUP() =XLOOKUP("Awais", A1:A10, B1:B10)
INDEX + MATCH =INDEX(B1:B10, MATCH("Awais", A1:A10, 0))

6. Date & Time Functions


Formula Example Result
TODAY() =TODAY()
NOW() =NOW()
DATEDIF() =DATEDIF("2020-01-01", "2025-01-01", "y") 5 years

7. Dynamic Array Functions


Formula Example Result
FILTER() =FILTER(A1:B10, A1:A10="Male")
SORT() =SORT(A1:A10)
UNIQUE() =UNIQUE(A1:A20)

You might also like