Need help on If usage

[pradeeplean]

I need to enter a score (such as :0,1,2,3-10) on a cell in excel
For that some scores have the same output answer (like Score '0-2' ,Poor, '3-5', can be better , '4-5', average)
How can I get score output to be displayed and what is the formula for that.

Kindly help with this.

Thanks & Regards,
Pradeep

[NBVC]

Perhaps something like this....

=Choose(A1+1,"Score '0-2' Poor", "'3-5' can be better" ," '4-5' average")

where A1 contains the inputted score.. and depending on the number the sequential item from the list is displayed... you can have of to 30 items...

or =Lookup(A1,{0,3,5},{"Score '0-2' Poor, "'3-5' can be better" ," '4-5' average"})

adjust numbers in { } to suit.

Edit: these too options overlap??? Should they???: "'3-5' can be better" ," '4-5' average"