Results 1 to 7 of 7

Thread: Letter in a Formula

  1. #1
    New Member
    Join Date
    Sep 2018
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Letter in a Formula

    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?

  2. #2
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,192
    Post Thanks / Like
    Mentioned
    67 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Letter in a Formula

    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.

    Regards Dante Amor

  3. #3
    New Member
    Join Date
    Sep 2018
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Letter in a Formula

    Quote Originally Posted by DanteAmor View Post
    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...e-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.

  4. #4
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,065
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Letter in a Formula

    On the template click the formulas tab and then click name manager and you will see what the letters refer to
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

  5. #5
    Board Regular Sam_D_Ben's Avatar
    Join Date
    Oct 2012
    Location
    New Jersey, USA
    Posts
    371
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Letter in a Formula

    Yeah you'll find it here.

    Sam_D_Ben

  6. #6
    New Member
    Join Date
    Sep 2018
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Letter in a Formula

    Quote Originally Posted by Sam_D_Ben View Post
    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?

  7. #7
    Board Regular MARK858's Avatar
    Join Date
    Nov 2010
    Location
    Southern England
    Posts
    11,065
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Letter in a Formula

    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

    EF
    17FrequencyPeriods
    18Annually1
    19Semi-Annually2
    20Quarterly4
    21Bi-Monthly6
    22Monthly12
    23Semi-Monthly24
    24Bi-Weekly26
    25Weekly52
    26Daily365

    Savings



    Last edited by MARK858; Aug 4th, 2019 at 08:03 PM.
    Test VBA on a copy of your data (remember you can't normally reverse the action)

    Please follow the forum Rules and Guidelines & please use Code tags around your code i.e. [CODE]your code[/CODE]

    To post a screenshot try one of these links
    MrExcel HTML Maker, RoryA addin (Win & Mac) or Borders-Copy-Paste

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •