Looking for formula to place score in a range of scores
 

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?

Sco 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

Looking for formula to place score in a range of scores
 

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.

--
Biff
Microsoft Excel MVP


"THIRDCOAST" wrote in message
...
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?

Sco 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