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