Excel Forum
Similar Content
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
Naming Cells in Excel to Make Using Formulas/Functions Easier
Tutorial: In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell w...



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.