Formula Exclusions?
Thankyou! was in an And Or Knot
"PCLIVE" wrote:
I'm not sure what your formula is supposed to do, but here is one way to
exclude "cab".
=IF(N11<"cab",RIGHT(N11,2))<"ab"
"nastech" wrote in message
...
Trying to do exlude one item from an equation. Is there a easy way for
example:
RIGHT(N11,2)<"ab",
but want to keep the one circumstance of: "cab", but get rid of the rest
of
the frab
thanks..
|