Formula Exclusions?
Thankyou! was in an And Or Knot
"Bob Phillips" wrote:
Test it first
=IF(RIGHT(N11,3)="cab","yes",IF(RIGHT(N11,2)<"ab" ,"no",""))
this is effectively an If ... Else. You will need to set appropriate return
values.
--
HTH
RP
(remove nothere from the email address if mailing direct)
"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..
|