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

[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

 

[Frank Kabel]

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

 

[Harald Staff]

Hey Joe

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

HTH. Best wishes Harald

 

[JE McGimpsey]

Or, ever so slightly less verbose (though somehow less emphatic):

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

 

[CLR]

=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

 

[sokevin]

yep i'd use the vlookup with the FALSE criteria. :

 

[Harald Staff]

Or, ever so slightly less verbose (though somehow less emphatic):

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

Doh! Of course. Thanks.

Best wishes Harald