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