Putting a formula in a cell, named it and use it in other cells repetitively

[Leslie Khoo]

Instead of typing a formula into an excel cell, is it possible for me to put it into a cell, name it as Threshold2 and use that cell name in another cell? This formula also refers to another cell named L. For example, I want to put the following formula in cell AWK6.
2+(0.5*INDIRECT(ADDRESS(ROW(),L+5,4))*INDIRECT(ADDRESS(ROW(),L+4,4)))

This formula also uses a named celled L found in AWB2.

I need to use the formula partially in another cell, cell AWB6 to AWB776. How do I use it?
I tried '=Threshold2' but instead of getting the calculated results, I got the text string '2+(0.5*INDIRECT(ADDRESS(ROW(),L+5,4))*INDIRECT(ADDRESS(ROW(),L+4,4)))'

How do I get the output of the above formula in cells AWB6 to AWB776?

 

[Dave Patton]

I did not evaluate your formula.

N.B. You can name a formula.

For the example shown above, I used Formula Name Manager
New =SumCandE
Refers to ='3c'!$C2+'3c'!$E2 3c is the sheet name Formula relates to row 2;
the row reference will change if formula is copied down.

Excel 2010
	C	D	E	F
2	4		2	6
3
4	10		20	30
5
3c

Cell Formulas
Range	Formula
F2	=SumCandE
F4	=SumCandE

Named Ranges
Name	Refers To	Cells
SumCandE	='3c'!$C5+'3c'!$E5