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:E6D6C32ECC8B4A2FA4B5EF243A9B042C(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 