December 2006
Beginner
1080 pages
30h 43m
English
Content preview from Special Edition Using Microsoft® Office Excel® 2007Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Chapter 29. Using Super Formulas in Excel
In this chapter
Using 3D Formulas to Spear Through Many Worksheets 824
Combining Multiple Formulas into One Formula 828
Calculating a Cell Reference in the Formula by Using the INDIRECT Function 830
Assigning a Formula to a Name 833
Replacing Multiple Formulas with One CSE Formula 838
Excel offers an amazing variety of formulas. This chapter covers some of the unorthodox formulas that you can build in Excel. In this chapter, you will learn about the following:
- Using a formula to add the same cell across many sheets
- Using a formula to reference the previous sheet
- Editing multiple formulas into one
- Assigning a formula to a name
- Letting data determine the cell reference to use with the
INDIRECTfunction ...