Results are out! Find what you need...fast. Get quick advice or join the chat
Hey there! Sign in to join this conversationNew here? Join for free

Excel Formula Problem

Announcements Posted on
    • Thread Starter
    • 0 followers
    Offline

    ReputationRep:
    Hi all

    I was wondering if anyone can help me with an EXCEL FORMULA I'm trying to perfect?

    PROBLEM: I have a range of numbers on my spreadsheet (11 to 17) and I want them to have the same value =2

    also a range of numbers (18 to 24) and I want to have the same value =1

    Can anyone send me the formula ASAP to:

    [Removed - please use PMs or post here]

    I'm getting very very :mad: with this problem.
    • 0 followers
    Offline

    ReputationRep:
    Am I right in thinking that you want if the number falls on one range you want to give it one value and if it's in the different range you want a different value? I can probably do whatever you're looking for but you are not very specific.


    This was posted from The Student Room's iPhone/iPad App
    • 20 followers
    Offline

    ReputationRep:
    make a table somewhere on the spreadsheet:
    11,2
    12,2
    ..
    17,2
    18,1
    19,1
    ..
    24,1

    the go back to your data array and do a vlookup next to the column of data

    i.e assume the numbers were in column A with first number being in a2, then in b2 type: =vlookup(a2,e2:f20,2,0), where e2:f20 is the table with the key you made above.

    hope this helps


    This was posted from The Student Room's iPhone/iPad App

Reply

Submit reply

Register

Thanks for posting! You just need to create an account in order to submit the post
  1. this can't be left blank
    that username has been taken, please choose another Forgotten your password?
  2. this can't be left blank
    this email is already registered. Forgotten your password?
  3. this can't be left blank

    6 characters or longer with both numbers and letters is safer

  4. this can't be left empty
    your full birthday is required
  1. By joining you agree to our Ts and Cs, privacy policy and site rules

  2. Slide to join now Processing…

Updated: July 20, 2012
New on TSR

GCSE mocks revision

Talk study tips this weekend

Article updates
Reputation gems: You get these gems as you gain rep from other members for making good contributions and giving helpful advice.