Okay, I found what was wrong with the value, but how do I lock in the range
to keep in from moving t I copy the formula downward?

"T. Valko" wrote:

Where do I create the table? On a seperate sheet?

You can create the table anywhere you want. In my example I put it on the
same sheet as the cell that you're checking. A lot of folks like to put
lookup tables on a separate dedicated sheet just for tables.

Let's say you put the table on Sheet2 in the range A1:B7.

Sheet1 A1 is the number you want to lookup and you want the result in Sheet1
B1. So, you'd enter this formula on Sheet1 in cell B1:

=IF(A1="","",VLOOKUP(A1,Sheet2!A1:B7,2))

Or, you can give the table a defined name and use that name in the formula.

Assume the table is on Sheet2 in the range A1:B7.

Navigate to Sheet2
Select the range A1:B7
In the name box, that little box directly above column A, type in a name for
the table. Example: MyTable
Then hit ENTER

Now you can use that name in the formula:

=IF(A1="","",VLOOKUP(A1,MyTable,2))


--
Biff
Microsoft Excel MVP


"JP" wrote in message
...
Where do I create the table? On a seperate sheet?

"T. Valko" wrote:

Create a 2 column table like this:

...........F..........G.....
1........0..........Poor
2........40........Below Average
3........50........Average
4........60........Above Average
5........70........Good
6........80........Very Good
7........90........Outstanding

A1 = some number

=IF(A1="","",VLOOKUP(A1,F1:G7,2))

0 - 39 = Poor
40 - 49 = Below Average
50 - 59 = Average
60 - 69 = Above Average
70 - 79 = Good
80 - 89 = Very Good
90+ = Outstanding


--
Biff
Microsoft Excel MVP


"JP" wrote in message
...
Another factor is a range...per your example:
=IF(95<A190,"Good",IF(90<A185,"Okay")) Total of 7.....

Now knowing all the details, can this be done?



"JP" wrote:

Yes, I need about 8 functions....I tried the equation below and it
excepted
the formula, but it wouldn't change the answer for each variable, it
just
posted the first.

"T. Valko" wrote:

You can use something like this if you have a "few" conditions:

=IF(A1=90,"Excellent",IF(A1=80,"Good",IF(A1=70, "Average","Need
Improvement")))

If you have more than a "few" conditions then your best approach is
to
create a 2 column lookup table. Post back if that might be the case.


--
Biff
Microsoft Excel MVP


"JP" wrote in message
...
Is it possible to put multiple IF functions to one cell? For
examples, say
I
want to assign different descriptions depending on what value
shows
up in
a
cell.