Uncategorized , , , , , ,

Advance Excel Mathematics Formula

Post By admin 12-December-2017

Advance Excel Mathematics Formula

SUM
What Does it Do ?
This function calculates the sum from a list of numbers.
Syntax
=SUM(Range1,Range2,Range3… through to Range30)

PRODUCT
What Does It Do ?
This function multiples a group of numbers together.
It is the same as using 2*3*5*10*3*7, which results in 6300.
Syntax
=PRODUCT(Number1,Number2,Number3… through to Number30)
Or
=PRODUCT(RangeOfNumbers)
Or
=PRODUCT(Number1,Range,Number2…)

QUOTIENT
What Does It Do ?
This function calculates the number of times a number can be divided by another number.
It ignores any remainder, only showing the whole number.
Syntax
=QUOTIENT(NumberToBeDivided,Divisor)

ABS
What Does it Do ?
This function calculates the value of a number, irrespective of whether it is positive or negative.
Syntax
=ABS(CellAddress or Number)

AVERAGE
What Does It Do ?
This function calculates the average from a list of numbers.
If the cell is blank or contains text, the cell will not be used in the average calculation.
If the cell contains zero 0, the cell will be included in the average calculation.
Syntax
=AVERAGE(Range1,Range2,Range3… through to Range30)