AVERAGE calculates the average of a series of numbers. Microsoft Excels power is in its ability to calculate and display results from data entered into its cells. A formula consists of special code which is entered into a cell.
Formulas range from basic mathematical operations such as addition and subtraction to complex engineering and statistical calculations.
Sign up or log in. This is because the cell contains or is equal to the formula and the value it calculates. Excel trendline formulas should only be used with XY scatter graphs because only in this chart type both the y-axis and x-axis are plotted as numeric values. Open the functions host workbook recalculate and all is fine again.