» Nesting Formulas in Excel 2007
CATEGORY - Excel Formula and Function
VERSION - Microsoft Excel 2007
To combine functions into one long nested power Formula:1. Insert the following formula into cell C12:
=SUMIF(TB_DB_Level3,A12,H:H)
2. Insert the following formula into blank cell :
= OFFSET(TB_DB_Level3,0,MonthSelectionNumber+2)
3. Select cell containing the OFFSET function (see step 2 above), In the Formula Bar select the formula without the equal (=) symbol, and press Ctrl+C to copy.
4. Click Cancel or Enter (the two buttons between the Name Box and the fx button on the left of the Formula Bar) to exit edit mode.
5. Select the cell containing the SUMIF function (cell C12), and in the Formula Bar, select the reference H1, and press Ctrl+V to paste.
Book Store:
Recommended Books:
- Special Edition Using Microsoft Access 2002
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Windows XP Inside Out
- Harry Potter and the Order of the Phoenix (Book 5)
No comments have been submitted.
