I'm attempting to create a forumlae in excel that will automatically display the following words according to the result of a calculation.
<0.5 = poor
0.5 ā 0.59 = below average
0.6 ā 0.69 = average
0.7 ā 0.79 = good
> 0.8 = excellent
My first try was this:
=IF(L2<=0.5,"Poor",IF(L2<0.6,"Below Average",IF(L2>0.6,"Average",IF(L2>=0.7,"Good",IF(L2>=0.8,"Excellent")))))
which obviously doesn't work but this is the kind of line I'm following.
Any ideas or suggestions greatly appreciated, I'm new to excel's logic functions.
Is it possible to create a logical forumlae that uses the score ranges like the ones above?
Cheers
P


LinkBack URL
About LinkBacks
Reply With Quote
