Excel 2007 : Multiple outcomes with text

First of all, my native language isn't English. I apologize for any spelling errors.

Here is my problem.
I have 2 columns. 1 with points (0-1500) the other should contain certain ranks according to the points.
There are 5 ranks
0-99
100-499
500-999
1000-1499
1500+

I can't seem to find a formula allowing me to add 5 different TEXT in 1 formula.
Can someone help?

+ How can I set the a spreadsheet in a way people only see the info (so not the menu, or the tabs or different sheets.
Example: (From some internet game)
https://spreadsheets.google.com/pub?...36&output=html


Thanks in advance!

Try: =LOOKUP(A1,{0,100,500,1000,1500},{"A","B","C","D","E"})

Dom

Whilst you can do it using IF formula I think LOOKUP is more flexible.

I should have asked to you to revise your thread title in line with the forum rules. Can you please do so and I'll have a look at the other.

I've never played much with Google Docs so not sure I can be of much help. As it's a different problem you should really start another thread on the subject.

Dom

Originally Posted by Domski

Whilst you can do it using IF formula I think LOOKUP is more flexible.

I should have asked to you to revise your thread title in line with the forum rules. Can you please do so and I'll have a look at the other.

I've never played much with Google Docs so not sure I can be of much help. As it's a different problem you should really start another thread on the subject.

Dom

I changed the title
If I used LOOKUP, it won't register numbers between the 0-500 or 500-1000 etc right?

Using my example values 0-99 will return A, 100-499 will return B, 500-999 will return C etc.

Was this what you were trying to achieve?

Dom

The lookup function basically creates a mini-array with different breakpoints. So in the equation that Dom posted for you, he created breakpoints at 100, 500, 1000, and 1500. So once the number surpasses that breakpoint, it'll use the other section of the array, the A, B, C, D, E.

Think of it kind of like a Vlookup, but instead of referencing an array, you're building your own. It's pretty flexible.

Sorry, as I said no clue about Google Docs.

Dom