IF Statement with multiple conditions

[janema]

I keep getting stuck when it comes to IF statements with multiple conditions. I am trying to get this formula to perform an calculation based on the cell that is not empty (checking two cell first). Is that possible? Thank you so much in advance for your help!

Here is what I am trying to write separated out:

IF column R2 shows "International" then return the value "int'l"
IF there is a value in column BZ, then divide column BZ by BU
If there is a value in column CC, then divide column CC by BU
If there is a value in column CE, then divide column CE by BU
If there is a value in both column CC and CE, then divide CC by BU
Otherwise, just divide column G by BU

I tried writing it this way, but it indicates

=IF(R2="International","int'l",IF(BZ2,<>"",BZ2/BU2),IF(CC2,<>"",CC2/BU2),IF(CE2,<>"",CE2/BU2),IF(AND(CC2,<>''",CE2,<>"",CC2/BU2),G2/BU2)))

I get this error when I try this formula:

 

[JoeMo]

Your data posted as an image is not particularly helpful, but I think this will avoid the problem you are having with the formula:

=IF(R2="International","int'l",IF(BZ2<>"",BZ2/BU2,IF(CC2<>"",CC2/BU2,IF(CE2<>"",CE2/BU2,IF(AND(CC2<>"",CE2<>""),CC2/BU2,G2/BU2)))))

 

[Alex Blakenburg]

Also it is never going to get to this:

IF(AND(CC2<>"",CE2<>"")

Since it will be caught by

IF(CC2<>""

before it gets there.

 

[janema]

Also it is never going to get to this:

IF(AND(CC2<>"",CE2<>"")

Since it will be caught by

IF(CC2<>""

before it gets there.

The formula should still work though, don't you think?

 

[Alex Blakenburg]

It will but you will get the same result without the additional if statement:

=IF(R2="International","int'l",IF(BZ2<>"",BZ2/BU2,IF(CC2<>"",CC2/BU2,IF(CE2<>"",CE2/BU2,G2/BU2))))