You are Here: Home

# Excel Formula Problem

Announcements Posted on
Would YOU be put off a uni with a high crime rate? First 50 to have their say get a £5 Amazon voucher! 27-10-2016
1. 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 with this problem.
2. 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
3. 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

## Register

Thanks for posting! You just need to create an account in order to submit the post
1. this can't be left blank
2. this can't be left blank
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
1. Oops, you need to agree to our Ts&Cs to register

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.

This forum is supported by:
Today on TSR

Poll
Useful resources

## Articles:

The Student Room tech wikiTech forum guidelines

### Need some cash?

How to make money running your own website.

## Groups associated with this forum:

View associated groups
Study resources

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

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