Nesting Formulas

A formula can be copied and pasted into the appropriate place within 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>

3:02 AM | 0 comments | Read More

Inserting/Editing Formulas

Inserting/Editing Formulas

• To open the Insert Function dialog box:

Select an empty cell and press <Shift+F3>.

• To open a Function Arguments dialog box: 

Select a cell containing a formula and press <Shift+F3>.

• To insert a new Formula into a cell using the Function

Arguments dialog box:
1.  Select an empty cell, and then type the = sign.
2.  Type the formula name and press <Ctrl+A>.

 To insert a formula by typing it while being guided by the
formula syntax tooltip:
1.  Select an empty cell, and then type the = sign followed by the
formula name and a left parenthesis, i.e. (.
2.  Press <Ctrl+Shift+A> (in Excel version 2003 the syntax appears
immediately after step 1 above).

2:58 AM | 0 comments | Read More