Excel functions are mathematical formulas that can be used to perform calculations or other actions on data in a worksheet.
Functions can be used to perform simple tasks, such as summing a column of numbers, or more complex tasks, such as calculating a mortgage payment.
Functions can be entered into a cell directly, or they can be used in conjunction with other formulas.
| FTEST | Compatibility |
 |
Returns the result of an F-test |
| FV | Financial |
|
Returns the future value of an investment |
| FVSCHEDULE | Financial |
|
Returns the future value of an initial principal after applying a series of compound interest rates |
| GAMMA | Statistical |
|
Returns the Gamma function value |
| GAMMA.DIST | Statistical |
|
Returns the gamma distribution |
| GAMMA.INV | Statistical |
|
Returns the inverse of the gamma cumulative distribution |
| GAMMADIST | Compatibility |
|
Returns the gamma distribution |
| GAMMAINV | Compatibility |
|
Returns the inverse of the gamma cumulative distribution |
| GAMMALN | Statistical |
|
Returns the natural logarithm of the gamma function, Γ(x) |
| GAMMALN.PRECISE | Statistical |
|
Returns the natural logarithm of the gamma function, Γ(x) |
| GAUSS | Statistical |
|
Returns 0.5 less than the standard normal cumulative distribution |
| GCD | Math and trigonometry |
|
Returns the greatest common divisor |
| GEOMEAN | Statistical |
|
Returns the geometric mean |
| GESTEP | Engineering |
|
Tests whether a number is greater than a threshold value |
| GETPIVOTDATA | Lookup and reference |
|
Returns data stored in a PivotTable report |
| GROWTH | Statistical |
|
Returns values along an exponential trend |
| HARMEAN | Statistical |
|
Returns the harmonic mean |
| HEX2BIN | Engineering |
|
Converts a hexadecimal number to binary |
| HEX2DEC | Engineering |
|
Converts a hexadecimal number to decimal |
| HEX2OCT | Engineering |
|
Converts a hexadecimal number to octal |
