In Excel, a formula calculates a value based on the values in other cells of the workbook. Excel displays the result of a formula in a cell as a numeric value.
A function is an abbreviated formula that performs a specific operation on a group of values. Excel provides more than 250 functions that can help you with tasks ranging from determining loan payments to calculating investment returns.