» Nesting Formulas
CATEGORY - Working with Formulas
VERSION - All Microsoft Excel Versions
A formula can be copied and pasted into the appropriate place in another formula in the Formula Bar by using the Ctrl+C and Ctrl+V keyboard shortcuts.
To combine Formulas into one long nested power Formula:
1. Insert the following formula into a cell:
=SUMIF(TB_DB_Level3,A12,G12)
2. Insert the following formula into an adjacent cell:
=OFFSET(TB_DB_Level3,0,MonthSelectionNumber+2)
3. In the Formula Bar of the second formula, select the formula without the = sign, and then press Ctrl+C.
4. Click Cancel or Enter (the two buttons between the Name Box and the formula in the Formula Bar) to exit edit mode.
5. Select the cell containing the first formula, and in the Formula Bar, select the reference G12, and then press Ctrl+V.
Book Store:
Recommended Books:
- PowerPoint® 2002 For Dummies®
- Personal Finance for Dummies
- Microsoft Access 2002 for Dummies
- Microsoft Excel 2002 Visual Basic for Applications Step by Step
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
No comments have been submitted.
