It is a Math and Trigonometry functions function that performs mathematical calculations, including basic arithmetic, conditional sums and products, exponents and logarithms, and trigonometric ratios.

For example, if you are calculating a stock option based on the Black-Sholes model, you will need the natural logarithm function "LN" in Excel, the normal distribution, "NORM.DIST" and the "EXP ...

Kinds of Functions Used in Excel. Microsoft's Excel program, widely used in business, comes with many built-in functions that perform mathematical and logical operations on spreadsheet data.