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