Score card help
Hi All, I have another excel 2003 problem i'm trying to solve.
I was hoping to link a score system to a cells with text in them.
example if a score entered by a simple sum formula is between 1 & 20, i would like to display some text, if its between 21 & 50, a differernt text, and so on up to 6 scores.
it seams simple enough but can twork it out, I have tried nesting IF(AND( but it only return on one score or errors
Any help would be gratefully recieved
Sof
|