Letter in a Formula

[rparedes]

Hi, I copied a formula and transfer it to my worksheet. However, it returns an "N/A" unlike from where I copied it from is working. Below is the formula

=(1+F7/k)^(k/p)-1

May I know how is it possible to use "k" and "p" in a formula? Do I need to assign a value to them?

 

[DanteAmor]

You can assign a named range to a cell.
For example, select cell F3, enter the Name Box and type the letter k. Select another cell say F5 for p.
Now write values ​​in cells F3 and F5.

 

[rparedes]

You can assign a named range to a cell.
For example, select cell F3, enter the Name Box and type the letter k. Select another cell say F5 for p.
Now write values ​​in cells F3 and F5.

Thank you! for the quick response. But, it isn't what I am looking for. I am actually studying the formula use on this template from Vertex

https://www.vertex42.com/Calculators/college-savings.html

On column N6 and N7 it contain formula that has letters, when I tried it on my own worksheet it doesn't work.

 

[MARK858]

On the template click the formulas tab and then click name manager and you will see what the letters refer to

 

[Sam_D_Ben]

Yeah you'll find it here.

 

[rparedes]

Yeah you'll find it here.

Ok, I saw it already. However, when I checked the formula assigned to "p"

=INDEX(Savings!$F$18:$F$26,MATCH(Savings!$F$12,Savings!$E$18:$E$26,0),1)

It has F18:F26 and E18:E26 upon checking on the worksheet, those cells has no values except that the graph is placed there. Can a graph be used as reference on a formula?

 

[MARK858]

The graph sits on top the data, if you left click and hold you'll find that you can drag it out of the way.

You'll find underneath that you have

Book1
	E	F
17	Frequency	Periods
18	Annually	1
19	Semi-Annually	2
20	Quarterly	4
21	Bi-Monthly	6
22	Monthly	12
23	Semi-Monthly	24
24	Bi-Weekly	26
25	Weekly	52
26	Daily	365
Savings