Microsoft Excel Mathematical Functions Example's for beginners

1.Mathematical Functions

1. AVERAGE

What is the use of Average formula?

Average of given numbers

Syntax of Average formula:

average(of this number, [and this number too..])

Examples of Excel Average formula:
average(2,4,6) = 4
average(A1:A5) = average of numbers in A1:A5

CLICK HERE FOR EXAMPLE'

2.MOD

What is the use of Mod formula?

Syntax of Mod formula:

mod(of this number, divided by this number)

Examples of Excel Mod formula:

mod(5,3) = 2

mod(3,5) = 3

1

CLICK HERE FOR EXAMPLE'

3.Rand Formula

What is the use of Rand formula?

Syntax of Rand formula:
rand()

Examples of Excel Rand formula:
rand() = who knows

CLICK HERE FOR EXAMPLE'

4.Round Formula

What is the use of Round formula?

Syntax of Round formula:
round(this number, to this many digits after decimal)

Examples of Excel Round formula:
round(1.2365,0) = 1
round(1.2365,2) = 1.24

CLICK HERE FOR EXAMPLE'

5.Sum Formula

What is the use of Sum formula?

Syntax of Sum formula:
sum(add this, [and this ..])

Examples of Excel Sum formula:
sum(1,2,3,4) = 10
sum(5.6,2.3) = 7.9

CLICK HERE FOR EXAMPLE'