Using multiple IF's and RANGEs in one formula

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

Hi Marvin,

Thanks - that's a nice simple method!

Best wishes
MKL