Hi

I have this data:

Capacity Factor
0-0.99
1.00-3.00
>3.00

Score
2.00
5.00
1.00


How do I write a function which will return the correct score for numbers in these ranges?

e.g. value is 0.3, score should be 2, value is 2.5, score should be 5.

Many thanks

MKL