Ranges?

[JoseK70]

In column A I have number of people which ranges from 1 to i think the highest is 92. In column B I want to assign a value if the column A number falls within a range. Like if the value in column A falls within 1 to 6 range I want to give it a value of x in column B. If the column A value falls within a range of 7 to 15 I want to give it a value of y in column B. Anybody know how to accomplish this? <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->

 

[Jonmo1]

Welcome to the board...

You can use a lookup formula...

=LOOKUP(A1,{1,7,16},{"x","y","z"})

Just keep the numbers sorted ascending from left to right.


Hope that helps.

 

[JoseK70]

Thanks for responding. I have column A with values lets say 6, 4, 18, 1, 66, 23, 2, 2, 5, and so on (they need to stay in that order). In column B I want .8 if the column A value falls in the 1 to 6 range, 1 if the column A value falls in the 7 to 15 range, and 1.2 if the column A value is 16 or higher. Thanks for the help.

Welcome to the board...

You can use a lookup formula...

=LOOKUP(A1,{1,7,16},{"x","y","z"})

Just keep the numbers sorted ascending from left to right.


Hope that helps.

 

[Jonmo1]

Instead of
=LOOKUP(A1,{1,7,16},{"x","y","z"})
try
=LOOKUP(A1,{1,7,16},{0.8,1,1.2})

 

[JoseK70]

Thanks