Prev: modifying T. Valko ws function
Next: Filter zeros from two columns, maybe on different rows
From: charlie on 1 Jun 2010 15:24
I need to write a formual for the following:
IF J1=R and L1= 3221 OR 3223 then N1 should be FALSE

J1 could be either R or C and L1 could be any numer of codes, but I need to
know which rows have an R and 3221 or an R and 3223. What's the easiest way
to write this?
From: "David Biddulph" groups [at] on 1 Jun 2010 15:37
=IF(AND(J1="R",OR(L1=3221,L1=3223)),FALSE,"Whatever you want N1 to be if
your condition isn't met").
--
David Biddulph


"charlie" <charlie(a)discussions.microsoft.com> wrote in message
news:E6D6C32E-CC8B-4A2F-A4B5-EF243A9B042C(a)microsoft.com...
> I need to write a formual for the following:
> IF J1=R and L1= 3221 OR 3223 then N1 should be FALSE
>
> J1 could be either R or C and L1 could be any numer of codes, but I need
> to
> know which rows have an R and 3221 or an R and 3223. What's the easiest
> way
> to write this?


From: Max on 1 Jun 2010 15:46
One way to flag it
In N1: =IF(AND(J1="R",OR(L1={3221,3223})),"x","")
Copy down. Insert a new 1st row, apply autofilter, filter out the "x".
--
Max
Singapore
---
"charlie" wrote:
> I need to write a formual for the following:
> IF J1=R and L1= 3221 OR 3223 then N1 should be FALSE
>
> J1 could be either R or C and L1 could be any numer of codes, but I need to
> know which rows have an R and 3221 or an R and 3223. What's the easiest way
> to write this?
From: Lars-�ke Aspelin on 1 Jun 2010 15:53
On Tue, 1 Jun 2010 12:24:01 -0700, charlie
<charlie(a)discussions.microsoft.com> wrote:

>I need to write a formual for the following:
>IF J1=R and L1= 3221 OR 3223 then N1 should be FALSE
>
>J1 could be either R or C and L1 could be any numer of codes, but I need to
>know which rows have an R and 3221 or an R and 3223. What's the easiest way
>to write this?


Try this formula in cell N1:

=IF(AND(J1="R",OR(L1=3221,L1=3223)),FALSE,"something else")

Replace "something else" with what you would to have if the condition
for FALSE is not met.

Hope this helps / Lars-�ke
 | 
Pages: 1
Prev: modifying T. Valko ws function
Next: Filter zeros from two columns, maybe on different rows