Thread: IF function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP JP is offline
external usenet poster
 
Posts: 103
Default 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.