Excel Formula 1

[Waidesworld]

I have about 2000 entries with values. These values are the average scores that each person received. It the score is between a certain value then I want to assign a "new value" to it in a third column. Example

A. Man 100.5 Score is between 100 and 105 so assign value of 20
B. Man 100.2 Score is between 100 and 105 so assign value of 20
C. Man 99.6 Score is between 90 and 99 so assign value of 19
D. Man 96.7 Score is between 90 and 99 so assign value of 19
and so on. Is there an easier way than manually inputting all the new values? Looking back it's like assigning a grade based on score.

 

[carrr]

Apply this technique to your specific breakdown. It should work for you:

http://www.usd.edu/~kbrady/vlookup.html

"'Tis an ill wind that blows no minds." - Malaclypse the Younger

 

[HansGermany]

Hallo,
I'm a German and sit here in Germany. My language-skills are not so good. But when I right understand your question, then is the solution for you in this case the function 'VLOOKUP'.

Carry out following steps:

1.) List in a new sheet all your data.
May be so:

wage categ
98 19
99 19
100 20
101 20
102 21
103 21

2.) Mark only the data-area (not the headlines).
By this marking, you can do the marking larger as the
data-area is. This is good for next inserts from you
in the next time.

3.) Give this marked date-area a name (only one word).
Use the name-field, first on the bar
or use the name-field -> Insert / Name / ...
Here we assume the name is called 'wages'

4.) Now you can use the function 'VLOOKUP'
=VLOOKUP(A5,wages,2,false)

A5 -> cell, where your value is
wages -> the name of your data-area
2 -> the row where the searched value is (here 'categ')
false -> This sounds mad, but is correct. It's for the
right looking so the rows in the date-area are
not sorted. Write it without rack your mind.

5.) Now, Excel is looking in cell A5,
looks then to the data-area,
and picked from the second (2-th) row the value

Have you all understand? I hope I could help you!
If you have questions about my description, so you can contact me to 1016-165@online.de

Bye!

Hans Porzel
45 years
from Steinwiesen / Bavaria
in Germany
(Saturnday, 2004-02-07, 05:20 a.m. (MEZ)

 

[Waidesworld]

Thanks guys, all sorted