Looking for formula to place score in a range of scores

[THIRDCOAST]

I'm building a scoring program that I need place scores in a "low",
"moderate", "high" location in a chart. If a score is ".39" it would fall in
the moderate range. if it was ".79" it would fall into the high range. Is
there some type of function that would review the score and place it into the
apprpriate cell?

Score: Range:
1. .39 Low 0-.29 ___
Moderate .30-.66 ___ <--- Should
go here.
High .67-1.00 ___

2. .79 Low 0-.29 ___
Moderate .30-.66 ___
High .67-1.00 ___ <--- Shoud
go here.

Thank you in advance for your assistance.
Scott

 

[T. Valko]

One way:

A1 = 0.39

Enter this formula in C1 and copy down to C3:

=IF(COUNT(A$1,--(A$1>=0))=2,IF(ROWS(C$1:C1)=MATCH(A$1,{0,0.3,0.67}),A$1,""),"")

Any value >1.0 will go to the High cell.