The Notebook Review forums were hosted by TechTarget, who shut down them down on January 31, 2022. This static read-only archive was pulled by NBR forum users between January 20 and January 31, 2022, in an effort to make sure that the valuable technical information that had been posted on the forums is preserved. For current discussions, many NBR forum users moved over to NotebookTalk.net after the shutdown.
Problems? See this thread at archive.org.

    Excel Help

    Discussion in 'Windows OS and Software' started by kvnrthr, Oct 4, 2010.

  1. kvnrthr

    kvnrthr Notebook Geek

    Reputations:
    5
    Messages:
    84
    Likes Received:
    0
    Trophy Points:
    15
    Can someone help me with an excel formula?

    I'm trying to make a table with ranges that correspond to a letter.
    For example, 95-100 is A, 90-94 is B, something like that. Thanks
     
    kvnrthr, Oct 4, 2010
    #1
  2. J&SinKTO

    J&SinKTO Notebook Deity

    Reputations:
    107
    Messages:
    767
    Likes Received:
    0
    Trophy Points:
    30
    Use the "IF" function, type that in the help box, Example 3 is scoring example to do what you describe.
     
    J&SinKTO, Oct 4, 2010
    #2
  3. kvnrthr

    kvnrthr Notebook Geek

    Reputations:
    5
    Messages:
    84
    Likes Received:
    0
    Trophy Points:
    15
    Thanks! I haven't used formulas in excel for years :p
     
    kvnrthr, Oct 4, 2010
    #3
  4. DetlevCM

    DetlevCM Notebook Nobel Laureate

    Reputations:
    4,843
    Messages:
    8,389
    Likes Received:
    1
    Trophy Points:
    205
    You could write VBA code too.... cough... if you are up for some programming :)
     
    DetlevCM, Oct 4, 2010
    #4