If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
IF formula question
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? |
#2
|
|||
|
|||
IF formula question
=IF(AND(J1="R",OR(L1=3221,L1=3223)),FALSE,"Whateve r you want N1 to be if
your condition isn't met"). -- David Biddulph "charlie" wrote in message ... 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? |
#3
|
|||
|
|||
IF formula question
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? |
#4
|
|||
|
|||
IF formula question
On Tue, 1 Jun 2010 12:24:01 -0700, 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? Try this formula in cell N1: =IF(AND(J1="R",OR(L1=3221,L1=3223)),FALSE,"somethi ng else") Replace "something else" with what you would to have if the condition for FALSE is not met. Hope this helps / Lars-Åke |
Thread Tools | |
Display Modes | |
|
|