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

SUMIF Formula

=SUMIF(A2:A9,5)
The formula above totals up the values from cell A2 to A9 based only on those cells that contain the value of 5. So if only cell A3 =5 and cell A5 = 5 as well and the other cells don't equal 5. Then the total value of the sumif formula would be 10. As the number 5 only appears twice in the cell range.

Read More..

Odd number formula

=Odd(6)
The answer to the formula above will be 7.
The Odd formula takes an even number like 6 and assigns it a value of the next available or higher odd number. So in this case the value in the brackets is an even number of 6 so the value that will be displayed is 7 as it is the next available Odd number for the number 6.

Read More..