Scribd
Upload
2 views5 pages

Microsoft Excel Basic Formulas With Examples

The document provides a comprehensive guide on basic Microsoft Excel formulas, including addition, subtraction, multiplication, and division, along with advanced functions like SUM, AVERAGE, MAX, MIN, and IF. Each formula is presented with its syntax, an example, and the expected result, allowing for practical application. Additionally, it covers functions for text manipulation, date/time, and error handling.

Uploaded by

nadeemrazage
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
2 views5 pages

Microsoft Excel Basic Formulas With Examples

The document provides a comprehensive guide on basic Microsoft Excel formulas, including addition, subtraction, multiplication, and division, along with advanced functions like SUM, AVERAGE, MAX, MIN, and IF. Each formula is presented with its syntax, an example, and the expected result, allowing for practical application. Additionally, it covers functions for text manipulation, date/time, and error handling.

Uploaded by

nadeemrazage
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

Microsoft Excel Basic Formulas with Examples

Addition (+)
Formula: =A2+B2

Example: A2=25, B2=15

Result: 40

Practice: __________________________

Subtraction (-)
Formula: =A2-B2

Example: 25-15

Result: 10

Practice: __________________________

Multiplication (*)
Formula: =A2*B2

Example: 12 x 8

Result: 96

Practice: __________________________

Division (/)
Formula: =A2/B2

Example: 100/20

Result: 5

Practice: __________________________

SUM
Formula: =SUM(B2:B6)

Example: 10,20,30,40,50

Result: 150

Practice: __________________________
AVERAGE
Formula: =AVERAGE(B2:B6)

Example: 10,20,30,40,50

Result: 30

Practice: __________________________

MAX
Formula: =MAX(B2:B6)

Example: 10,20,30,40,50

Result: 50

Practice: __________________________

MIN
Formula: =MIN(B2:B6)

Example: 10,20,30,40,50

Result: 10

Practice: __________________________

COUNT
Formula: =COUNT(B2:B6)

Example: 5 numbers

Result: 5

Practice: __________________________

COUNTA
Formula: =COUNTA(A2:A6)

Example: 5 names

Result: 5

Practice: __________________________

IF
Formula: =IF(B2>=50,"Pass","Fail")

Example: 80
Result: Pass

Practice: __________________________

Percentage
Formula: =(B2+C2+D2)/300*100

Example: 80,75,90

Result: 81.67%

Practice: __________________________

LEFT
Formula: =LEFT(A2,3)

Example: Ahmed

Result: Ahm

Practice: __________________________

RIGHT
Formula: =RIGHT(A2,2)

Example: Ahmed

Result: ed

Practice: __________________________

LEN
Formula: =LEN(A2)

Example: Ahmed

Result: 5

Practice: __________________________

TODAY
Formula: =TODAY()

Example: Current date

Result: Today

Practice: __________________________
NOW
Formula: =NOW()

Example: Current date/time

Result: Now

Practice: __________________________

ROUND
Formula: =ROUND(85.678,2)

Example: 85.678

Result: 85.68

Practice: __________________________

ABS
Formula: =ABS(-25)

Example: -25

Result: 25

Practice: __________________________

SQRT
Formula: =SQRT(81)

Example: 81

Result: 9

Practice: __________________________

POWER
Formula: =POWER(5,2)

Example: 5,2

Result: 25

Practice: __________________________

COUNTIF
Formula: =COUNTIF(B2:B6,">70")

Example: 80,70,95,60,85
Result: 3

Practice: __________________________

SUMIF
Formula: =SUMIF(B2:B6,">70")

Example: 80,70,95,60,85

Result: 260

Practice: __________________________

IFERROR
Formula: =IFERROR(A2/B2,0)

Example: B2=0

Result: 0

Practice: __________________________

VLOOKUP
Formula: =VLOOKUP("Ahmed",A2:B3,2,FALSE)

Example: Ahmed

Result: 70

Practice: __________________________

You might also like