Well & Truly stuck on a cell formula!

D

dangleberry

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
 
J

JE McGimpsey

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)
 
D

dangleberry

Sorry, no joy with that I'm afraid. I think I'm maybe getting a bit out
of my depth here!

I was thinking (very roughly) along the lines of something like this:

=IF(F2<0.001 AND >0.250)"class7"*OR(IF(F2<0.251 AND >0.500)"class6"
etc. etc.

Obviously this actual formula wont work, but I don't know where to put
the brackets and commas etc.

Any firther help would be greatly appreciated.

Cheers
Mark
 
D

Dominic

Mark,

You may want to give JE's suggestion a more thorough examination.

It works perfectly for me if I am understanding your request.
 
K

KePaHa

IF statements allow you to nest up to seven times. So if that is not too
limiting for what you need, you could do somehting like:

=IF(C5<=0.025,"lowest",IF(C5<=0.05,"middle",IF(C5<=0.075,"higher","highest")))
 
D

dangleberry

Cheers, that last one has worked a treat. I'm sure the previous
suggestion works, I'm just not too knowledgable when it comes to
in-depth Excel stuff, so its more likely me than anything else as to
why I couldn't get it to work.

Thanks all for your help

Kind Regards
Mark
 
D

Dominic

Mark,

Glad you got it working.

If you end up with more than seven "class" distinctions, just write back and
we'll try to get you up and running with JE's suggestion.

Cheers.
 
Top