the sum, product, average, etc.) for a supplied set of values the sum, product, average, etc.) for a list or database, with the option to ignore hidden rows and error values (New in Excel 2010) Returns the remainder from a division between two supplied numbers Returns the integer portion of a division between two supplied numbers Returns the positive square root of a given number Returns the result of a given number raised to a supplied power ![]() Returns the product of a supplied list of numbers Returns the sum of a supplied list of numbers ![]() Returns the Least Common Multiple of two or more supplied numbers ![]() Returns the Greatest Common Divisor of two or more supplied numbers Returns the sign (+1, -1 or 0) of a supplied number Note that some of the Excel math functions listed below were introduced in recent versions of Excel, and so are not available in earlier versions.Įxcel Math and Trig Functions List Basic Numeric Information ![]() Selecting a function link will take you to a full description of the function, with examples of use and common errors. The tables below list all the current built-in Excel math functions, grouped by category, to help you to find the function you need. Note that further math-related Excel functions are also provided in the Excel Statistical Functions and Excel Engineering Functions categories. The Excel Math Functions perform many of the common mathematical calculations, including basic arithmetic, conditional sums & products, exponents & logarithms, and the trigonometric ratios.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |