What is a function in Excel example?

Functions are predefined formulas in Excel. They eliminate laborious manual entry of formulas while giving them human-friendly names. For example: =SUM(A1:A3). The function sums all the values from A1 to A3.

A function is a preset formula, that helps perform mathematical, statistical, and logical operations. Once you are familiar with the function you want to use, all you have to do is enter an equal sign (=) in the cell, followed by the name of the function and the cell range it applies to.

Here you will find a detailed tutorial on 100+ Excel Functions. The functions have been grouped into categories, so that you can easily find the function you need. Each Excel function is covered in detail with Examples.