Formula Exclusions?
 

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..

Formula Exclusions?
 

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..

Formula Exclusions?
 

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..

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..

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..