You are Here: Home

# Excel Formula Problem Watch

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

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

### Grade boundaries not out until results day

What does this mean for you?

Poll
Useful resources

## Articles:

The Student Room tech wikiTech forum guidelines

### 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
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.