Scribd
Upload
37 views4 pages

Excel Formula Notes

This document provides a list of common Excel formulas along with their functions and examples. Key formulas include SUM, AVERAGE, IF, VLOOKUP, and others that perform various calculations and data manipulations. Each formula is accompanied by a brief description and an example for clarity.

Uploaded by

subhajit.gowebs
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
37 views4 pages

Excel Formula Notes

This document provides a list of common Excel formulas along with their functions and examples. Key formulas include SUM, AVERAGE, IF, VLOOKUP, and others that perform various calculations and data manipulations. Each formula is accompanied by a brief description and an example for clarity.

Uploaded by

subhajit.gowebs
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 Notes

1. SUM

Adds all the numbers in a range of cells.

Example: =SUM(A1:A5)

2. AVERAGE

Calculates the average of numbers.

Example: =AVERAGE(B1:B10)

3. IF

Performs a logical test and returns one value for TRUE and another for FALSE.

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

4. VLOOKUP

Searches for a value in the first column of a table and returns a value in the same row.

Example: =VLOOKUP(1001, A2:C10, 2, FALSE)

5. HLOOKUP

Searches for a value in the first row and returns a value in the same column.

Example: =HLOOKUP("Q1", A1:D4, 2, FALSE)

6. INDEX

Returns the value of a cell at the intersection of a row and column.

Example: =INDEX(A1:C3, 2, 3)
Excel Formula Notes
7. MATCH

Returns the relative position of an item in a range.

Example: =MATCH(39, B1:B5, 0)

8. CONCATENATE / CONCAT

Joins several text strings into one.

Example: =CONCATENATE(A1, " ", B1)

Newer: =CONCAT(A1, " ", B1)

9. LEN

Returns the number of characters in a string.

Example: =LEN(A1)

10. TRIM

Removes all extra spaces from text, leaving single spaces between words.

Example: =TRIM(A1)

11. NOW

Returns the current date and time.

Example: =NOW()

12. TODAY

Returns the current date.

Example: =TODAY()
Excel Formula Notes
13. COUNT

Counts how many numbers are in a list.

Example: =COUNT(A1:A10)

14. COUNTA

Counts all non-empty cells.

Example: =COUNTA(A1:A10)

15. COUNTIF

Counts cells that meet a condition.

Example: =COUNTIF(A1:A10, ">5")

16. SUMIF

Adds numbers that meet a condition.

Example: =SUMIF(A1:A10, ">5")

17. ROUND

Rounds a number to a specified number of digits.

Example: =ROUND(A1, 2)

18. AND

Returns TRUE if all arguments are TRUE.

Example: =AND(A1>0, B1<5)


Excel Formula Notes
19. OR

Returns TRUE if any argument is TRUE.

Example: =OR(A1>0, B1<5)

20. ISERROR

Checks if a value is an error.

Example: =ISERROR(A1/B1)

You might also like