Excel Formulas and Functions ǀ Data Analytics
Excel formulas and functions help you calculate and analyze data. A formula is a calculation you create yourself, while a function is a ready-made calculation built into Excel. Formulas Every Excel formula begins with an equal sign ( = ). This tells Excel that the cell contains a calculation, not ordinary text or a number. For example: =1+2 Excel will display 3 , not the text =1+2 . Formulas can use numbers, such as 5 , or cell references, such as: =L1/L7 This divides the value in cell L1 by the value in cell L7 . Cell references There are two main types of cell references: Type Example What happens when copied Relative reference L1/L7 Changes based on the formula’s new location Absolute reference $L$1/$L$7 Always refers to the same cells Relative references are the default. For example, if you...