Scribd
Upload
7 views2 pages

Excel Functions With Its Examples

The document provides a list of common Excel functions along with examples and their results. Functions include Sum, Average, Count, Max, Min, Round, ABS, LEN, Concatenate, Upper/Lower, and text manipulation functions like Right, Left, and Mid. Each function is illustrated with a specific formula and a sample output for clarity.

Uploaded by

Irshad
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
7 views2 pages

Excel Functions With Its Examples

The document provides a list of common Excel functions along with examples and their results. Functions include Sum, Average, Count, Max, Min, Round, ABS, LEN, Concatenate, Upper/Lower, and text manipulation functions like Right, Left, and Mid. Each function is illustrated with a specific formula and a sample output for clarity.

Uploaded by

Irshad
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Excel Functions With its Examples

1) Sum: =sum(A1, B1) A1= 5 | B1= 5 Result => 10


2) Sumif: =sumif(A1:A7, “Ahmad”, B1:B7) | Result => 770

Sums according to a condition!!!


3) Average: =Average(A3:B1) | it is the same as sum but write average
instead of sum in the above function.
4) Count: =count(A1:B10) Result => for example 5 of the selected cells
contain numbers so the result will be 5.
5) CountIf: =countif(A1:A5, “>150”) | Result => 3
A1 200 Because there
A2 150 are only three
A3 130 number greater
A4 170
than 150.
A5 220
6) Max: =max(A1:A5) | Result => the biggest number in the selected range
is 200 for example.
7) Min: =max(A1:A5) | Result => the biggest number in the selected range
is 200 for example.
8) Round: =round(select the range for example from A1 cell to A6 which can
be written as A1:A6) | Number => 5080.125
=round(5080.125, 2) | Result => 5080.13
9) ABS: =abs(-20) | Result => 20
10) LEN: finds the length of the letters of a word like:
Word: Irfan =len(Irfan) | Result => 5
11) Concatenate: joins to words: like: Irfan Khan
=concatenate(A1,A2) | result => IrfanKhan
A1= Irfan A2= Khan
12) Upper/Lower: =upper(computer) => COMPUTER
=lower(COMPUTER) => computer
13) Right, Left and Mid: it gives you the letters you want to extract from a
word or name.
=right(A3, 5)
=left(C5, 2)
=mid(B2, 3, 4)

You might also like