Modulus formula to find the remainder

=MOD(value, divisor)
Examples:
=MOD(3,2)
OR
=MOD(A2,B2)
Let's say cell A2 = 3 and cell B2 = 2 as the first modulus formula above.
The answer would be a remainder of 1. As 3 divided by 2 will give a remainder of 1. That is how the formula works.

Read More..

Product formula

=PRODUCT(A2,B2,C2)
Let's say the value in cell A2 is 2, in cell B2 is 2 and in cell C2 is 3. The Product formula is a function that multiplies the cell references separated by commas with each other. You can use a combination of numbers and cell references. You can have up to 255 comma separated values or ranges. The value that will be displayed by the formula above will be 12. The product formula works like this: 2 x 2 x 3 which is A2 x B2 x C2.

Read More..

Combine formula

=COMBIN(4,2)
The excel formula above will display the different kind of combinations you can have with the number 2 into 4. This is regardless of the order of the combinations. So if you had optional modules A,B,C and D and you had to take any 2 of them, then you would have 6 combinations being:
AB, AC, AD, BC, BD, and CD

Read More..

PERMUT formula

=PERMUT(3,2)
The excel formula above will display the number of ordered combinations you can have for 3 items by using 2 items out of 3. Let's say you had the options A, B,and C, which equates to 3 as above. Also, let's say you can take only two options in different orders as sugested by the 2 after the comma. So the formula above will give you 6 as the answer, as there are 6 possible ordered combinations. The following explains the ordered combinations you can have. So out of A, B, and C the 6 possible combinations you can have are:  AB, BA, BC,CB, AC and CA.

Read More..

Random number formula

=RAND()
The excel formula above will display random numbers with decimal places, primarily between 0 and 1. Which as you fill it down the excel.spreadsheet will generate random numbers. Such as, 0.13452789 and 0.97856453.

Read More..

Random number genarator formula for specific range

=RAND()*(65-1)+1
The excel formula above will generate random numbers between 1 and 65 as you fill it down an excel spreadsheet.  The (65-1)+1 bit tells excel to only select numbers between 1 and 65. Simplified it would be (higher number - lower number) + lower number. The RAND()* part randomises the numbers in the range. A sample result would be 56.90875721 or 1.34168538.

Read More..

PI Area formula

=(10/2)^2*PI()
The excel formula above calculates the area for the diameter of 10.  which gives the value of 78.53982. It is calculated by finding the radius of the diameter 10. Then multiply the radius to the power of 2. Then multiplying the resulting value by PI.

Read More..