Well & Truly stuck on a cell formula!
 

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


--
dangleberry
------------------------------------------------------------------------
dangleberry's Profile: http://www.excelforum.com/member.php...o&userid=33877
View this thread: http://www.excelforum.com/showthread...hreadid=536561

Well & Truly stuck on a cell formula!
 

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

Well & Truly stuck on a cell formula!
 

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


--
dangleberry
------------------------------------------------------------------------
dangleberry's Profile: http://www.excelforum.com/member.php...o&userid=33877
View this thread: http://www.excelforum.com/showthread...hreadid=536561

Well & Truly stuck on a cell formula!
 

Mark,

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

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



"dangleberry" wrote:


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


--
dangleberry
------------------------------------------------------------------------
dangleberry's Profile: http://www.excelforum.com/member.php...o&userid=33877
View this thread: http://www.excelforum.com/showthread...hreadid=536561

Well & Truly stuck on a cell formula!
 

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

"dangleberry" wrote:


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


--
dangleberry
------------------------------------------------------------------------
dangleberry's Profile: http://www.excelforum.com/member.php...o&userid=33877
View this thread: http://www.excelforum.com/showthread...hreadid=536561

Well & Truly stuck on a cell formula!
 

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


KePaHa Wrote:
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")))

"dangleberry" wrote:


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


--
dangleberry

------------------------------------------------------------------------
dangleberry's Profile:
http://www.excelforum.com/member.php...o&userid=33877
View this thread:
http://www.excelforum.com/showthread...hreadid=536561




--
dangleberry
------------------------------------------------------------------------
dangleberry's Profile: http://www.excelforum.com/member.php...o&userid=33877
View this thread: http://www.excelforum.com/showthread...hreadid=536561

Well & Truly stuck on a cell formula!
 

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.

"dangleberry" wrote:


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


KePaHa Wrote:
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")))

"dangleberry" wrote:


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


--
dangleberry

------------------------------------------------------------------------
dangleberry's Profile:
http://www.excelforum.com/member.php...o&userid=33877
View this thread:
http://www.excelforum.com/showthread...hreadid=536561




--
dangleberry
------------------------------------------------------------------------
dangleberry's Profile: http://www.excelforum.com/member.php...o&userid=33877
View this thread: http://www.excelforum.com/showthread...hreadid=536561