|
Change Language:
Microsoft Excel Common Used Functions
Microsoft Excel Most Common Used Functions and Formulas
Microsoft Excel is a product of Microsoft Office suite. MS Excel is used for manage official spread sheets. I am explaining few most common used Microsoft Excel's functions.
Sum Function This function is used to get sum of numbers. Usage: =Sum(A1:A10) or =Sum(12,4,6,7,3.4) = 32.4
Average Function This function returns average of multiple numbers. Usage: =Average(A1:A10) or =Average(4,6,7,5,344,3) = 61.5
Count Function This function counts the number of cells in a range that contain numbers. Usage: =Count(A1:A10) or =Count(12,"a","n","b",3.3) = 2
Max Function This function returns the largest number or value from given list. Usage: =Max(A1:A10) or =Max(12.4,54,33,544,23,22.3) = 544
Min Function This function returns the smallest number or value from given list. Usage: =Min(A1:A10) or =Min(12.4,54,33,544,23,22.3) = 12.4
Abs Function This function return absolute number from given number or number without sign. Usage: =Abs(A1) or =Abs(-44.3) = 44.3
Bin2Dec Function This function converts binary value into decimal number. Usage: =Bin2Dec(A1) or =Bin2Dec(11111110) = 254
Bin2Hex Function This function converts binary value into hexa number. Usage: =Bin2Hex(A1,6) or =Bin2Hex(11111110, 6) = 0000FE
Bin2Oct Function This function converts binary value into octal number. Usage: =Bin2Oct(A1) or =Bin2Oct(11111110) = 376 Char Function This function returns character from Ascii code. Usage: =Chat(A1) or =Chat(65) = A
Code Function This function returns ascii code of a character. Usage: =Code(A1) or =Code("A1") = 65
CountBlank Function This function counts blank cells from a range. Usage: =CountBlank(A1:A10)
Product Function This function multiplies all given numbers. Usage: =Product(A1:A10) or =Product(1,3,4,5) = 60
See Also or Related Articles:
|