CATEGORY: Working with Formulas VERSIONS: All Microsoft Excel Versions

Using keyboard shortcuts 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.

Screenshot // Nesting Formulas

Rate this tip 1 2 3 4 5   RATING: 2.41   VIEWS: 43310 Email Tip Print Tip Add to My Tips

READER COMMENTS (view all comments)

No comments have been submitted.

REGISTERED USERS - Click here to post comments GUESTS (Click here to register) Name Comment Title Comments

Word 2002: The Complete Reference Microsoft Windows XP Step by Step (With CD-ROM) Adventure Capitalist: The Ultimate Road Trip Financial Statement Analysis with S&P insert card Positioning: The Battle for Your Mind The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)

RELATED MICROSOFT EXCEL TIPS

Create User Forms in Microsoft Excel Using Loops in VBA in Microsoft Excel The Best Shortcut Keys in Microsoft Excel Writing Your First VBA Function in Excel Add Combo Box to a Sheet in Microsoft Excel Formulas to calculate Loan payments in Microsoft Excel Array variables using VBA in Microsoft Excel Create an Amortization Schedule in Microsoft Excel Find duplicates items in combine columns in Microsoft Excel Vlookup Formula – Organizing the Data Table

• Excel VBA books
• Accounting books
• Business Plans
• MS Office books
• Taxes books