1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Anybody Experienced In Excel

Discussion in 'BlackHat Lounge' started by thinktank1, Oct 23, 2012.

  1. thinktank1

    thinktank1 Regular Member

    Joined:
    Jun 3, 2012
    Messages:
    217
    Likes Received:
    78
    Location:
    travelling on the information highway
    So long story short, I need to change some numerical grades to letter grades within the cell. I know how to use vlookup but say there is a cell that has the grade of 96, I need to change this to an A+. It needs to be within the two variable data table. Really stuck on this and cant figure it out.
     
  2. mirrorman

    mirrorman Newbie

    Joined:
    Sep 24, 2011
    Messages:
    47
    Likes Received:
    14
    Let's assume your grades are in Column A

    Create a new Column and use this formula

    =IF(A1>90,"A+",IF(A1>80,"A",IF(A1>60,"B",IF(A1>50,"C", "D"))))

    Then copy this down all the rows.

    These are nested "IF" statements that take the form IF(condition,true,false)

    If this doesn't make sense to you, let me know the exact gradings, and I'll do the exact formula for you.
     
  3. rockong

    rockong Power Member

    Joined:
    Jan 19, 2012
    Messages:
    661
    Likes Received:
    283
    Occupation:
    Wealth advisor to internet marketers.
    Home Page:
    Just create an IF function..it'll do exactly what you need. And yeah, what mirrorman says looks right.
     
  4. rockong

    rockong Power Member

    Joined:
    Jan 19, 2012
    Messages:
    661
    Likes Received:
    283
    Occupation:
    Wealth advisor to internet marketers.
    Home Page:
    excel reminds me of my corporate days...SMH
     
  5. thinktank1

    thinktank1 Regular Member

    Joined:
    Jun 3, 2012
    Messages:
    217
    Likes Received:
    78
    Location:
    travelling on the information highway
    this is for one of my courses lol
     
  6. thinktank1

    thinktank1 Regular Member

    Joined:
    Jun 3, 2012
    Messages:
    217
    Likes Received:
    78
    Location:
    travelling on the information highway
    thanks but what I am trying to do is change to the letter grade in replacement of the numerical grade within the cell.


     
  7. mirrorman

    mirrorman Newbie

    Joined:
    Sep 24, 2011
    Messages:
    47
    Likes Received:
    14
    Is there a specific reason you can't do what I suggested and then paste the resulting values into the original cells?
     
    Last edited: Oct 24, 2012
  8. VCC-bank

    VCC-bank BANNED BANNED

    Joined:
    Apr 17, 2010
    Messages:
    87
    Likes Received:
    9
    i have tried the if statement and if working fine as the first replier says.
     
  9. thinktank1

    thinktank1 Regular Member

    Joined:
    Jun 3, 2012
    Messages:
    217
    Likes Received:
    78
    Location:
    travelling on the information highway
    yes it does work, but there is a certain feature I am looking for that can do it without copying it from an external cell. thanks for your help
     
  10. mirrorman

    mirrorman Newbie

    Joined:
    Sep 24, 2011
    Messages:
    47
    Likes Received:
    14
    Unless you can explain better, then I think you're going to be having to use VBA/Macros to accomplish what you're asking.
     
  11. jheyslow

    jheyslow Senior Member

    Joined:
    May 11, 2010
    Messages:
    864
    Likes Received:
    709
    Occupation:
    trying new things
    @OP just send me the file I do this for free.
     
  12. GiorgioB

    GiorgioB Supreme Member

    Joined:
    Feb 28, 2012
    Messages:
    1,288
    Likes Received:
    1,317
    Occupation:
    Making money
    Location:
    Touching the Sky
    just use ctrl H mass replace.. or else create a rule to highlight cells between 90 and 100 and just paste A+ in all.. repeat with 80-90, etc.. 5 min max.
     
  13. jheyslow

    jheyslow Senior Member

    Joined:
    May 11, 2010
    Messages:
    864
    Likes Received:
    709
    Occupation:
    trying new things
    I think the only solution for this is VBA or Macros.