IF function
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.
|