Scribd
Upload
3 views2 pages

Excel Functions Short Notes

This document provides a concise overview of various Excel functions, including their purpose and examples of usage. Functions covered include SUM, AVERAGE, COUNT, IF, VLOOKUP, and text manipulation functions like LEFT and CONCAT. Each function is explained with a brief description and an illustrative example.

Uploaded by

ro 14
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 views2 pages

Excel Functions Short Notes

This document provides a concise overview of various Excel functions, including their purpose and examples of usage. Functions covered include SUM, AVERAGE, COUNT, IF, VLOOKUP, and text manipulation functions like LEFT and CONCAT. Each function is explained with a brief description and an illustrative example.

Uploaded by

ro 14
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 Functions – Short Notes with Examples

SUM(): Adds numbers in a range.


Example: =SUM(A1:A5)

AVERAGE(): Finds the average of numbers.


Example: =AVERAGE(B1:B5)

COUNT(): Counts cells containing numbers.


Example: =COUNT(A1:A10)

COUNTA(): Counts non-empty cells.


Example: =COUNTA(A1:A10)

COUNTBLANK(): Counts empty cells.


Example: =COUNTBLANK(A1:A10)

MAX(): Finds the largest value.


Example: =MAX(C1:C10)

MIN(): Finds the smallest value.


Example: =MIN(C1:C10)

IF(): Performs logical test.


Example: =IF(A1>=40,'Pass','Fail')

SUMIF(): Adds values based on condition.


Example: =SUMIF(A1:A10,'Apples',B1:B10)

COUNTIF(): Counts cells meeting a condition.


Example: =COUNTIF(A1:A10,'>=50')

VLOOKUP(): Searches vertically for a value.


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

HLOOKUP(): Searches horizontally for a value.


Example: =HLOOKUP('Jan',A1:F5,2,FALSE)

LEFT(): Extracts text from left.


Example: =LEFT(A1,4)

RIGHT(): Extracts text from right.


Example: =RIGHT(A1,2)

MID(): Extracts text from middle.


Example: =MID(A1,2,3)

LEN(): Counts characters in text.


Example: =LEN(A1)

UPPER(): Converts text to uppercase.


Example: =UPPER(A1)

LOWER(): Converts text to lowercase.


Example: =LOWER(A1)

CONCAT(): Joins text from multiple cells.


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

TODAY(): Returns current date.


Example: =TODAY()
NOW(): Returns current date and time.
Example: =NOW()

You might also like