IF formula question

[charlie]

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?

 

[David Biddulph]

=IF(AND(J1="R",OR(L1=3221,L1=3223)),FALSE,"Whatever you want N1 to be if
your condition isn't met").

 

[Max]

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

 

[Lars-Åke Aspelin]

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