© David Slager 2016

David Slager, Essential Excel 2016, 10.1007/978-1-4842-2161-7_7

7. Creating and Using Formulas

David Slager

(1)Fort Wayne, Indiana, USA

Formulas are created to give us the results from such things as adding the items we buy at the store, computing our taxes, computing our car’s miles per gallon, and so on. A formula in Excel is an expression that is computed and the results are placed in the cell that contains the formula. You can enter your own formulas or you can use of one Excel’s many built-in formulas. Excel’s built-in formulas are called functions.

After reading and working through this chapter you should be able to

  • Enter formulas into a cell or into the formula bar

  • Enter formulas using the correct order of precedence

  • Copy ...

Get Essential Excel 2016: A Step-by-Step Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.