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.

Howie,
From the above lines in your original post, really thought you wanted the
"FALSE" indicated as the Value_IF_True, and "TRUE" as the value otherwise.
That's why I swapped it around. I'm confused. Could you re-clarify your
original intent?
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--