View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dangleberry
 
Posts: n/a
Default 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