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

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

Last edited: