Excel Forum

Excel Magic Trick #209: Formula Or Function Confusion

Learn about the differences and similarities between a formula and a function! See: 1) definitions for formulas and functions; 2) Math formulas; 3) Text Formulas; 4) the EFFECT, TEXT and AVERAGE functions; and 5) how to combine functions, cell references and text strings in formulas that will get you on your way towards more complex formulas.
Formula is a thing (calculating, retrieving data, creating text strings) you put in a cell that has an equal sign as the first character
Function is a built-in code that simplifies formulas for actions such as adding, taking an average or converting numbers to text

Got a Question? Ask it Here in the Forum.