IF function help

[girth69]

Hi,

I need some help creating an IF function. I have a list of salar
brackets e.g A 0 - 10,000
B 10,000 - 20,000
C 20,000 - 30,000
D 30,000 - 40,000
etc

On a seperate spreadsheet i have different cells with peoples salarie
in. In a seperate cell underneath their salary cells, i have an empt
cell that needs to have the relevant letter in that shows which ban
they fall into A,B,C,D etc.

What i need is an IF function in the blank cell that will automaticall
come up when a persons salary is typed in.

E.g : - if i type in 24,000 into the salary cell, i want the blank cel
to then come up with the letter C.

Thank

 

[RagDyeR]

With salary in C1,
Set up a datalist in an out-of- the-way location, say Y1 to Z10, such as
this:

Y Z

0 A
10001 B
20001 C
30001 D
40001 E
.... etc.

Then try this formula in the "empty" cell:

=LOOKUP(C1,Y1:Z10)

--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

message
Hi,

I need some help creating an IF function. I have a list of salary
brackets e.g A 0 - 10,000
B 10,000 - 20,000
C 20,000 - 30,000
D 30,000 - 40,000
etc

On a seperate spreadsheet i have different cells with peoples salaries
in. In a seperate cell underneath their salary cells, i have an empty
cell that needs to have the relevant letter in that shows which band
they fall into A,B,C,D etc.

What i need is an IF function in the blank cell that will automatically
come up when a persons salary is typed in.

E.g : - if i type in 24,000 into the salary cell, i want the blank cell
to then come up with the letter C.

Thanks