IF statement with multiple criteria

[swatty27]

Hi there, was wondering if I could get help with an If statement I was trying to perform. I was trying to sort through to columns which are either buy/sell in on column and put/call in the other for four different possiblities:

Buy Put (BP), Buy Call(BC), Sell Put(SP), Sell Call(SC)

The formula I tried to utilize is below:

=IF(AND(Y6=$Y$2,Z6=$Z$2),BP,IF(AND(Y6=$Y$3,Z6=$Z$3),SC,IF(AND(Y6=$Y$3,Z6=$Z$2),SP,IF(AND(Y6=$Y$2,Z6=$Z$3),BC))))

The cell references I put in the formula were cells with the words Buy,Sell, Put and Call. This is using Excel 2007.

Any help would be appreciated.

Thanks,

Dan

 

[buxtongt]

Welcome to the board. I tested your formula a little and I believe you need =true after all of the and statements. Hope this helps.

 

[swatty27]

I tried doing this but was unsuccessful, am I placing the =true part incorrectly? Where exactly is it supposed to go? Thanks I appreciate the help.

=IF(AND(Y7=$Y$3,Z11=$Z$3,=TRUE),BP,IF(AND(Y11=$Y$4,Z11=$Z$4,=TRUE),SC,IF(AND(Y11=$Y$5,Z11=$Z$3,=TRUE),SP,IF(AND(Y11=$Y$3,Z11=$Z$4,=TRUE),BC))))

 

[buxtongt]

It should look like and(part1,part2)=true

Hope this helps.

 

[swatty27]

Hmmm it still didn't work when I tried doing this:

=IF(AND(Y7=$Y$3,Z11=$Z$3)=TRUE,BP,IF(AND(Y11=$Y$4,Z11=$Z$4)=TRUE,SC,IF(AND(Y11=$Y$5,Z11=$Z$3)=TRUE,SP,IF(AND(Y11=$Y$3,Z11=$Z$4)=TRUE,BC))))

 

[buxtongt]

Are the ranges you are looking at and comparing to set correctly? Some of them look off, Y7 vs. Y11 and $Y$3-5 specifically. Thanks.