Skew Formula

=Skew(A2:A9)
Skews looks at the deviation of a value from the mean. If list of values are mostly above the average then the skew value will be negative. If the values are mostly below the mean then the skew value will be positive.

Read More..

Avedev Formula

=AVEDEV(Range)
Example:
=AVEDEV(A2:A9)
The function above is short for average deviation. It calculates the mean of the range and also calculates its deviation altogether.

Read More..

SIN, COS and TAN Formulas

To use the SIN, COS and TAN to convert degree angles you also have to wrap the degree angle with the RADIANS formula. The SIN, COS and TAN formulas can only read RADIANS not Degrees. Examples are as follows:
=SIN(RADIANS(90))
=COS(RADIANS(9))
=TAN(RADIANS(9))

Read More..

Degrees and Radians

1 Radian = 57.3 degrees.
To convert degrees to radian
=RADIANS(Number of Degrees)
To convert radian to degrees
=DEGREES(Number of Radians)

Read More..

SUMIFS Formula

=SUMIFS(range_with_sum_value,criteria range_1,criteria_range_1_value,criteria range_2,criteria_range_2_value)
E.G.:
Looking at the formula below. Column A is the sales prices column. Column B is the types of products bought. Column C is the number of orders. The formula below is establishing the total sales price for Cakes that were bought more than once in each order.
=SUMIFS(A2:A9,B2:B9,"Cakes",C2:C9,>1)
Cells A2:A9 in the formula is the range to sum. The statement, 'B2:B9,"Cakes"' bases the cells being added up in cells A2:A9 solely on the related rows that say Cakes. The final statement, '>1', specifies to the formula to select those prices where the cake orders were greater than 1.

Read More..

SUMPRODUCT

=SUMPRODUCT(Units,Prices)
Let's say cells A2 to A9 holds a list of units sold per order. Let's also say cells B2 to B9 holds a list of sales prices for each order. The sum product formula as shown adds up the total of cells A2 to A9 and multiplies it by the sum of cells B2 to B9. So if the total value of cell range A2:A9 is 10 and the total value of cell range B2:B9 is 30. The sum product value would be 300.
E.G.:
=SUMPRODUCT(A2:A9,B2:B9)

Read More..

Integer Formula

"=INT(300.89)" = 300
OR
=INT(A2)
The excel formula above effectively drops the decimal numbers on any value or value in a cell reference. So the value that will be displayed from 300.89 will be 300.

Read More..