One interp .. Maybe in say, K3:

=IF(OR(AND(J3B3,J3<C3),AND(J3E3,J3<F3),AND(J3H3 ,J3<I3)),FALSE,TRUE)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Howie" wrote in message
...
I have got something like:
=IF(OR(AND(J3B3,J3<C3),(AND(J3E3,J3<F3)),(AND(J3 H3,J3<I3)),TRUE,FALSE))

In words, I am trying to say:

IF the value in X is greater than a, AND less than b, OR greater
than c AND less than d, OR greater than e AND less than f, then
FALSE, otherwise TRUE.

I really would appreciate any help here.

TIA.

H.


--
Howard Coakley
e-mail... howard<dot}coakleyatcoakley<dot].codotuk
Skype ID: howie10 (get skype from www.skype.com)