Scribd
Upload
3 views3 pages

Essential Excel Functions Guide

This document provides a comprehensive list of common MS Excel functions along with their syntax and examples. Functions include SUM, MIN, MAX, AVERAGE, COUNT, and more, each demonstrated with specific usage examples. The document serves as a quick reference for users looking to utilize Excel functions effectively.

Uploaded by

sakusingh03
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
3 views3 pages

Essential Excel Functions Guide

This document provides a comprehensive list of common MS Excel functions along with their syntax and examples. Functions include SUM, MIN, MAX, AVERAGE, COUNT, and more, each demonstrated with specific usage examples. The document serves as a quick reference for users looking to utilize Excel functions effectively.

Uploaded by

sakusingh03
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

MS EXCEL FUNCTIONS WITH SYNTAX AND EXAMPLES

1. SUM()

Syntax: =SUM(number1, number2,…)

Example: =SUM(A1:A5)

2. MIN()

Syntax: =MIN(range)

Example: =MIN(B1:B10)

3. MAX()

Syntax: =MAX(range)

Example: =MAX(B1:B10)

4. AVERAGE()

Syntax: =AVERAGE(range)

Example: =AVERAGE(C1:C5)

5. COUNT()

Syntax: =COUNT(range)

Example: =COUNT(D1:D10)

6. POWER()

Syntax: =POWER(number, power)

Example: =POWER(5,2)

7. CEILING()

Syntax: =CEILING(number, significance)

Example: =CEILING(5.3,1)

8. FLOOR()

Syntax: =FLOOR(number, significance)

Example: =FLOOR(5.8,1)
9. CONCAT()

Syntax: =CONCAT(text1, text2,…)

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

10. TRIM()

Syntax: =TRIM(text)

Example: =TRIM(" Saket Singh ")

11. REPLACE()

Syntax: =REPLACE(old_text, start_num, num_chars, new_text)

Example: =REPLACE("Excel",2,3,"123")

12. SUBSTITUTE()

Syntax: =SUBSTITUTE(text, old_text, new_text, [instance_num])

Example: =SUBSTITUTE("I like tea","tea","coffee")

13. LEFT()

Syntax: =LEFT(text, num_chars)

Example: =LEFT("Saket",2)

14. RIGHT()

Syntax: =RIGHT(text, num_chars)

Example: =RIGHT("Saket",3)

15. MID()

Syntax: =MID(text, start_num, num_chars)

Example: =MID("Saket",2,3)

16. UPPER()

Syntax: =UPPER(text)

Example: =UPPER("saket")
17. LOWER()

Syntax: =LOWER(text)

Example: =LOWER("SAKET")

18. PROPER()

Syntax: =PROPER(text)

Example: =PROPER("saket singh")

19. NOW()

Syntax: =NOW()

20. TODAY()

Syntax: =TODAY()

21. DATEDIF()

Syntax: =DATEDIF(start_date, end_date, unit)

Example: =DATEDIF("01-01-2020","01-01-2025","Y")

22. VLOOKUP()

Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

Example: =VLOOKUP(A2, A1:C10, 3, FALSE)

23. HLOOKUP()

Syntax: =HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

Example: =HLOOKUP(A2, A1:Z5, 2, FALSE)

24. IF()

Syntax: =IF(logical_test, value_if_true, value_if_false)

Example: =IF(A1>=50,"Pass","Fail")

You might also like