Pat,

A decision table is often use to map out a number of different condition
combinations. For instance, you would put all the different conditions that
affect K22 across the top, then all the conditions that affect J98/M98 down
the side, and in the various intersection points you state what result you
want in that condition.

Often, some conditions will give the same result as another, or are an
impossible condition, but by mapping it out, you get a very clear picture of
what to do.

In this case, as you have now solved it, it would be of no help. The biggest
problem I have had with this thread (no big deal, but for future
information), is in understanding exactly what was allowable and in what
circumstances. This is why I took some many guesses at it, it wasn't clear
at the start that there were 2 combinations that were permissible.

Anyway, you are sorted now, so we have been successful.

Regards

Bob

"Pat" wrote in message
...
Thank you for your persistence, the following gave the closest result:

=OR(AND(K22<"QS", J98M98),AND(K22="QS", J98<=M98))

when modified it gave the result I was looking:

=OR(AND(K22<"QS", J98<M98),AND(K22="QS", J98<=M98))

Which cell is this going in, J98 or M98, and how about laying out a
decision
table?

J98, what is a decision table and would it be of help now?

regards
Pat