One way:

In a separate location, perhaps a second sheet enter

A B
1 0.001 class7
2 0.250 class6
3 0.500 class5
....
7 40.000 class1


Then in your data sheet, use

B2: =VLOOKUP(F2,Sheet2!A:B,2,TRUE)


In article ,
dangleberry
wrote:

Hi Folks

I'm a newbie to this forum so please go easy on me :)

I have an Excel sheet, and I would like to create a formula whereby the
number I enter into once cell determines a text phrase in another - ie:

If I enter a number between 0.001 and 0.249 in cell F2, then in cell B2
the phrase 'class7' is input. If i enter a number between 0.250 and
0.499, the in cell B2 the phrase class6 is input - and so on.....

Any help would be greatly appreciated, I'm no beginner but I certainly
aint no expert! ;)

Kind Regards
Mark