Would like to input 3 letters into a cell, each having a different numerical value

Discussion in 'Excel' started by jdoon5261, Oct 2, 2016.

  1. jdoon5261

    jdoon5261

    Joined:
    Oct 2, 2016
    Messages:
    1
    Likes Received:
    0
    Hi Everyone,
    New to the forum. I'm a CATE teacher and am working on a professionalism rubric that I can carry with me in the lab. I am getting stuck on this part. I would like to input one of 3 letters into a cell and have it correspond to a numerical value that a formula in another cell will see as that numerical value.
    A layman's example would be: Y=100, P=75, n=50. I have this formula "=SUM(F2*0.25)+(((G2+H2)/2)*0.25)+(((J2+K2)/2)*0.25)+(((M2+N2)/2)*0.25)" in another cell that would need the numerical value of the letter in order for it to work.
    I know my formula is somewhat amateurish but I'm a noob to all of this.
    Thanks
    John.
     
    jdoon5261, Oct 2, 2016
    #1
    1. Advertisements

  2. jdoon5261

    Becky Administrator

    Joined:
    Aug 3, 2011
    Messages:
    34
    Likes Received:
    3
    Welcome to the forum :)

    Could you talk me through your formula please, and also give some details on what isn't working?
     
    Becky, Oct 3, 2016
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. alabil

    Finding specific value

    alabil, Mar 7, 2012, in forum: Excel
    Replies:
    0
    Views:
    266
    alabil
    Mar 7, 2012
  2. Stormy4757
    Replies:
    1
    Views:
    703
    XLPadawan
    Jun 9, 2016
  3. Jorge
    Replies:
    0
    Views:
    555
    Jorge
    Aug 27, 2013
  4. Hwalker1
    Replies:
    2
    Views:
    507
    XLPadawan
    Jun 13, 2016
  5. Siegfried

    sum based on value in a range

    Siegfried, Jun 27, 2014, in forum: Excel
    Replies:
    0
    Views:
    598
    Siegfried
    Jun 27, 2014
  6. DanM
    Replies:
    1
    Views:
    367
    XLPadawan
    Jun 13, 2016
  7. hyukfgh
    Replies:
    2
    Views:
    609
    hyukfgh
    Oct 16, 2014
  8. Shivesh
    Replies:
    1
    Views:
    272
    XLPadawan
    Jun 14, 2016
Loading...