Newbie: How to: 1 to 4 = fail, 5 = pass, 6 = very good, 7 = excellent

  • Thread starter Thread starter joe serrano
  • Start date Start date
J

joe serrano

How can I get a reference so a number value, as a product of a sum can be
refeenced as a word,

1 to 4 = fail, 5 = pass, so on

Do I use a text function or what?

thanks in advance.
joe
 
Hi Joe
maybe something like
=IF(AND(A1>=1,A1<=4),"fail",IF(A1=5,"pass","don't know"))
 
Hey Joe

with the score in A1:
=CHOOSE(A1,"Kill","Kill","Kill","Kill","Smack","Cool","Nobel prize")

HTH. Best wishes Harald
 
Or, ever so slightly less verbose (though somehow less emphatic):

=CHOOSE(MAX(1,A1-3),"Kill","Smack","Cool","Nobel prize")
 
=VLOOKUP(A1,wordtable,2,false)

"wordtable" is a Named Range with the numbers you expect down one column and
the word responses you want to give corresponding down the column just to
the right of that one..........

Vaya con Dios,
Chuck, CABGx3
 
JE McGimpsey said:
Or, ever so slightly less verbose (though somehow less emphatic):

=CHOOSE(MAX(1,A1-3),"Kill","Smack","Cool","Nobel prize")
Click to expand...

Doh! Of course. Thanks.

Best wishes Harald
 
Back
Top