2 IF statements in the same cell

[pink]

'IF(AND(OR(L9=1,L9=2),OR(M9=3,M9=4)),Sheet1!$D$32, IF(AND(OR(L9=3,L9=4),OR(M9=1,M9=2)),Sheet1!$D$33, IF(OR(M9=3,M9=4),Sheet1!$D$33,0)))'

This is my original formula, it works, but I also need to include another completely unrelated IF statement that says

'IF(OR(M9=3,M9=4), Sheet1!$D$32,0)'

This formula also works, but I need them to work together and independantly, in the same cell. If the second statement is true, I still need it to check if the first one is true, and to add the values together.

Is there any way to do that?

Thanks.

 

[tactps]

It sounds like you just want to add them:

=IF(AND(OR(L9=1,L9=2),OR(M9=3,M9=4)),Sheet1!$D$32, IF(AND(OR(L9=3,L9=4),OR(M9=1,M9=2)),Sheet1!$D$33, IF(OR(M9=3,M9=4),Sheet1!$D$33,0)))+IF(OR(M9=3,M9=4), Sheet1!$D$32,0)

Is that what you want?

 

[pink]

Yes, that worked, thank you. I didn't realize you could do that.