Scribd
Upload
31 views2 pages

Basic Excel Formulas Summary

This document provides a summary of basic Excel formulas, detailing their names, purposes, explanations, examples, and expected outputs. Key formulas include SUM for addition, AVERAGE for calculating means, and IF for conditional checks. The document serves as a quick reference for efficient spreadsheet tasks and data analysis.

Uploaded by

siidkaboi
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
31 views2 pages

Basic Excel Formulas Summary

This document provides a summary of basic Excel formulas, detailing their names, purposes, explanations, examples, and expected outputs. Key formulas include SUM for addition, AVERAGE for calculating means, and IF for conditional checks. The document serves as a quick reference for efficient spreadsheet tasks and data analysis.

Uploaded by

siidkaboi
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

Basic Excel Formulas – Summary Table

This document summarizes basic Excel formulas with their names, purposes, explanations,
examples, and results. These formulas are essential for efficient spreadsheet tasks,
reporting, and data analysis.

# Formula Name Purpose / Explanation Example Formula Output


Usage
1 SUM Add Adds multiple =SUM(A1:A3) 60
numbers numeric
(Total) values
together.
2 AVERAGE Calculate Returns the =AVERAGE(B1:B3) 20
average average
(mean) of
selected
numbers.
3 IF Condition Returns one =IF(C1>50, "Pass", "Fail") Pass
check value if the
condition is
TRUE,
another if
FALSE.
4 COUNT Count Counts how =COUNT(D1:D5) 2
numbers many cells
only contain
numeric
values.
5 COUNTA Count Counts all =COUNTA(E1:E3) 2
non- non-blank
empty cells
cells (including
text,
numbers,
etc).
6 MAX Find Returns the =MAX(F1:F4) 7
largest highest
number number from
the selected
range.
7 MIN Find Returns the =MIN(F1:F4) 2
smallest lowest
number number from
the selected
range.
8 CONCATENATE Combine Joins two or =CONCATENATE(G1, " ", G2) Ahmed
text more text Ali
values into
one string.
9 If formula Making if used to for =if(A1>=50,”Passed”,”Failed”) Passed or
Decision condition and failed
(passed, takes to
Failed) arguments
10 TODAY() Current Returns the =TODAY() 2025-07-
date only current 18
system date.
Updates
automatically.
11 NOW() Current Returns the =NOW() 2025-07-
date & current 18 10:33
time system date AM
and time.
12 XLOOKUP Vertical Looks up a =XLOOKUP(101, A2:C10, 2, Employee
and value in the FALSE) name
horizontal first column
lookup of a range,
returns value
from another
column or
row.
13 If formula Making if used to for =if(A1>=95,”A+”,if(A1>=90,”A”, A+, A, A-,
Decision condition and If(A1>=85,”A-“…))) …
(A+,A,A- takes to
,..) arguments
14 LEN Count Counts the =LEN("Hello") 5
characters number of
characters in
a cell
(including
spaces).
15 Rank Displays Tells how the =rank(A1,$A1$:$A5$) 1,2,3,4,
the rank value greater
value than each

You might also like