Mathematical Formula

 


No.FormulaDescription
1SUMAdds a range of numbers
2AVERAGECalculates the average of a range of numbers
3COUNTCounts the number of cells that contain numbers
4MAXReturns the largest value in a range of numbers
5MINReturns the smallest value in a range of numbers
6ROUNDRounds a number to a specified number of decimal places
7INTRounds a number down to the nearest integer
8ABSReturns the absolute value of a number
9POWERRaises a number to a specified power
10SQRTReturns the square root of a number
11LOGReturns the logarithm of a number using a specified base
12EXPReturns e raised to the power of a specified number
13SINReturns the sine of an angle
14COSReturns the cosine of an angle
15TANReturns the tangent of an angle
16PIReturns the value of pi (3.14159265358979)
17RADIANSConverts degrees to radians
18DEGREESConverts radians to degrees
19SUMPRODUCTCalculates the sum of the products of corresponding arrays
20MODReturns the remainder after division