Anybody Experienced In Excel

 

Results 1 to 13 of 13
So long story short, I need to change some numerical grades to letter grades within ...
  1. #1
    thinktank1's Avatar
    thinktank1 is offline Regular Member
    Join Date
    Jun 2012
    Location
    travelling on the information highway
    Posts
    217
    Thanks
    11
    Thanked 77 Times in 45 Posts

    Default Anybody Experienced In Excel

    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. #2
    mirrorman is offline Newbies
    Join Date
    Sep 2011
    Posts
    44
    Thanks
    8
    Thanked 10 Times in 6 Posts

    Default Re: Anybody Experienced In Excel

    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. #3
    rockong's Avatar
    rockong is offline Power Member
    Join Date
    Jan 2012
    Location
    Anywhere...everywhere
    Posts
    614
    Thanks
    58
    Thanked 252 Times in 156 Posts

    Default Re: Anybody Experienced In Excel

    Just create an IF function..it'll do exactly what you need. And yeah, what mirrorman says looks right.

  4. #4
    rockong's Avatar
    rockong is offline Power Member
    Join Date
    Jan 2012
    Location
    Anywhere...everywhere
    Posts
    614
    Thanks
    58
    Thanked 252 Times in 156 Posts

    Default Re: Anybody Experienced In Excel

    excel reminds me of my corporate days...SMH

  5. #5
    thinktank1's Avatar
    thinktank1 is offline Regular Member
    Join Date
    Jun 2012
    Location
    travelling on the information highway
    Posts
    217
    Thanks
    11
    Thanked 77 Times in 45 Posts

    Default Re: Anybody Experienced In Excel

    this is for one of my courses lol

  6. #6
    thinktank1's Avatar
    thinktank1 is offline Regular Member
    Join Date
    Jun 2012
    Location
    travelling on the information highway
    Posts
    217
    Thanks
    11
    Thanked 77 Times in 45 Posts

    Default Re: Anybody Experienced In Excel

    thanks but what I am trying to do is change to the letter grade in replacement of the numerical grade within the cell.


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

  7. #7
    mirrorman is offline Newbies
    Join Date
    Sep 2011
    Posts
    44
    Thanks
    8
    Thanked 10 Times in 6 Posts

    Default Re: Anybody Experienced In Excel

    Is there a specific reason you can't do what I suggested and then paste the resulting values into the original cells?
    Last edited by mirrorman; 10-23-2012 at 10:30 PM.

  8. #8
    VCC-bank is offline Banned - see signature
    Join Date
    Apr 2010
    Posts
    87
    Thanks
    5
    Thanked 9 Times in 6 Posts

    Default Re: Anybody Experienced In Excel

    i have tried the if statement and if working fine as the first replier says.
    This member has been permanently banned from BHW.

  9. #9
    thinktank1's Avatar
    thinktank1 is offline Regular Member
    Join Date
    Jun 2012
    Location
    travelling on the information highway
    Posts
    217
    Thanks
    11
    Thanked 77 Times in 45 Posts

    Default Re: Anybody Experienced In Excel

    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. #10
    mirrorman is offline Newbies
    Join Date
    Sep 2011
    Posts
    44
    Thanks
    8
    Thanked 10 Times in 6 Posts

    Default Re: Anybody Experienced In Excel

    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. #11
    jheyslow's Avatar
    jheyslow is offline Senior Member
    Join Date
    May 2010
    Posts
    835
    Thanks
    3,528
    Thanked 667 Times in 206 Posts

    Default Re: Anybody Experienced In Excel

    @OP just send me the file I do this for free.

  12. #12
    GiorgioB's Avatar
    GiorgioB is offline Supreme Member
    Join Date
    Feb 2012
    Location
    Touching the Sky
    Posts
    1,233
    Thanks
    629
    Thanked 1,248 Times in 629 Posts

    Default Re: Anybody Experienced In Excel

    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. #13
    jheyslow's Avatar
    jheyslow is offline Senior Member
    Join Date
    May 2010
    Posts
    835
    Thanks
    3,528
    Thanked 667 Times in 206 Posts

    Default Re: Anybody Experienced In Excel

    I think the only solution for this is VBA or Macros.


Similar Threads

  1. Help with Excel.
    By deathlyreaver in forum Black Hat SEO
    Replies: 4
    Last Post: 05-19-2011, 05:29 AM
  2. Need some help in Excel
    By virtualc08 in forum BlackHat Lounge
    Replies: 4
    Last Post: 02-14-2011, 02:55 AM
  3. $20 Excel Help
    By chaser232 in forum Black Hat SEO
    Replies: 1
    Last Post: 12-10-2010, 05:26 AM
  4. Replies: 11
    Last Post: 09-19-2010, 07:01 PM
  5. Need Some Excel Macros Made (VBA for Excel)
    By curiosity in forum Hire a Freelancer
    Replies: 5
    Last Post: 11-12-2009, 03:41 AM

Bookmarks

Posting Permissions

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




BlackHatWorld on Twitter BlackHatWorld on FaceBook


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108