Excel Formula Problem
Computing and PC help and advice, programming, games, digital audio, mobile phones and electronic miscellanea.
| Announcements | Posted on | |
|---|---|---|
| Enter our travel-writing competition for the chance to win a Nikon 1 J3 camera | 21-05-2013 | |
-
- Reputation:
- Thread Starter
- Junior Member
- Location: Liverpool
- Posts: 31
Excel Formula ProblemHi 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.
Last edited by Illusionary; 20-07-2012 at 22:03. -
- Reputation:
- New Member
- Posts: 5
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 -
- Reputation:
- Peer Of The TSR Realm
- Posts: 1,828
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
