Formula Matematika dalam Excel

Ada beberapa Formula matematika diantaranya yaitu Average, Int, Mod, Rand, Round dan Sum 

-----------------------------------

Average

FormulaWhat 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
-----------------------------------

Int
What is the use of Int formula?
Converts a decimal number to integer lower than it

Syntax of Int formula:
int(this number)

Examples of Excel Int formula:
int(1.2365) = 1
----------------------------------

Mod
What is the use of Mod formula?
Tells you what is the reminder after dividing one number with another

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
----------------------------------

Rand
What is the use of Rand formula?
Gives you a random number to play with

Syntax of Rand formula:
rand()

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

Round

What is the use of Round formula?
Rounds a number to nearest decimal you specify

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
----------------------------------

Sum
What is the use of Sum formula?
Adds a bunch of numbers


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

Sumber : http://chandoo.org/