Multiple Criteria in IF Statement in Excel

[Shanyna05]

Hi,

I have data that I am trying to analyze by using an IF statement in excel. I can get it to work in its simplest form try to combine the criteria into one, I think I am missing something.

Here is what my formula looks like in its silest form and it works but I want to be able to combine all three into one. I think I have to use an OR but I couldn't get the coding correct.

Multiple Criteria - works individual, need it to gether in one cell
IF(B8="FP",IF(C8="LBR",IF(D8="99",TRUE)))
IF(B8="RT",IF(C8="LBR",IF(D8="MP",TRUE)))
IF(B8="1N",IF(C8="LBR",IF(D8="99",TRUE)))

Tried this OR but it's not working correctly
IF(OR(B8="FP",C8="LBR",D8="MP"),IF(OR(B8="RT",C8="LBR",D8="MP"),"TRUE"))

Thoughts? Or is it better to do this via a Macro?

Thanks in advance!

[Special-K]

Try

=IF(AND(C8="LBR",OR(AND(OR(B8="FP",B8="1N"),D8="99"),AND(B8="RT",D8="MP"))),TRUE,FALSE)

[Pete_UK]

Try this:

IF(OR(B8="FP",B8="1N"),IF(AND(C8="LBR",D8="99"),TRUE,FALSE),IF(B8="RT",IF(AND(C8="LBR",D8="MP"),TRUE,FALSE),FALSE))

I've put a few FALSE returns, for completeness.

Hope this helps.

Pete