SUM A function that adds together cells you reference in the formula. Many errors in Excel formulas are caused by a failure to fully understand the order in which mathematical operators are evaluated. Functions perform specific calculations in a particular order based on the specified values called arguments or parameters.
By adding formulas and functions to your Excel sheet you instantly gain access to a wealth of information regarding your data and can conduct complex calculations with ease.
29 tips for working with formulas and functions video version here 500 formula examples with full explanations. The myriad formulas and functions in Excel are in large part what makes it such a uniquely powerful program. Excel automatically recalculates the value of cell A3. The functions are designed for easy lookup and formatting of large pool of data whereas the advanced excel formula are implemented to get new information from a given particular set of data.