Join TSR now and chat about whatever you’re intoSign up now

Excel Formula Problem Watch

    • Thread Starter
    Offline

    0
    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.
    Offline

    0
    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
    Offline

    3
    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
 
 
 
Write a reply… Reply
Submit reply
Updated: July 20, 2012
TSR Support Team

We have a brilliant team of more than 60 Support Team members looking after discussions on The Student Room, helping to make it a fun, safe and useful place to hang out.

Poll
How are you feeling about Results Day?
Useful resources

Articles:

The Student Room tech wikiTech forum guidelines

Quick link:

Unanswered technology and computers threads

Sponsored features:

Web Legend

Win a Macbook Air!

Blog about setting up a website for a chance to win in our Web Legend competition.

Groups associated with this forum:

View associated groups

The Student Room, Get Revising and Marked by Teachers are trading names of The Student Room Group Ltd.

Register Number: 04666380 (England and Wales), VAT No. 806 8067 22 Registered Office: International House, Queens Road, Brighton, BN1 3XE

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