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