Chapter 6. Working with Formulas

[ LiB ]

Chapter 6. Working with Formulas

Many people use a worksheet to perform mathematical calculations. By using formulas, if a value in a referenced cell changes, any formula based on the cell automatically adjusts to accommodate the new value. Excel can accommodate both simple formulas, such as adding two values together, and complex formulas, such as adding two values together and multiplying the result by another number. In addition, Excel can include the values from many different worksheet cells .

In this chapter, you'll learn how to:

• Create simple and compound formulas

• Edit formulas

• Copy formulas

• Create an absolute reference in a formula

• View formulas in the worksheet

• Understand common formula error messages

[ LiB ]