Nested IF statements

[B-dub]

I have three different IF statements (below) in my spreadsheet and I'd like to "merge" these into one big IF statement (i.e., put all three of these in one cell). What would be the syntax?

=IF(AND(C2=$O$1,(F2*$O$9)>G2),(F2*$O$4)*$M$16,G2*$M$16)

=IF(AND(B2=$O$1,(G2/$O$16)>F2),(G2/$O$3)*$M$16,F2*$M$16)

=IF(AND(B2<>$O$1,C2<>$O$1,(F2/$O$23)>(G2*$O$9)),(F2/$O$6)*$M$16,(G2*$O$4)*$M$16)


Thanks.

[Søren Larsen]

Is it posible to upload a sample workbook?

[B-dub]

Column H in the attached (labeled "Calculation") is where the multiple IF statements need to go. The first three rows (shaded red) contain IF statement #1 that I pasted in my original post above. The second three rows (green) have the second IF statement. The final three rows (blue) have the third IF statement. The goal is to get all three of these IF statements into one cell.

The idea here is that I do a different calculation based on whether Value1 is 'Cat', Value2 is 'Cat', or if neither one of them is 'Cat'.

[Søren Larsen]

In H2:

=IF(C2=$O$1,IF(AND(C2=$O$1,(F2*$O$9)>G2),(F2*$O$4)*$M$16,G2*$M$16),IF(B2=$O$1,IF(AND(B2=$O$1,(G2/$O$16)>F2),(G2/$O$3)*$M$16,F2*$M$16),IF(AND(B2<>$O$1,C2<>$O$1,(F2/$O$23)>(G2*$O$9)),(F2/$O$6)*$M$16,(G2*$O$4)*$M$16)))

And copy down. Perhaps some elements of the formula are redundant now, but it should work.

[B-dub]

Thank you, that worked. This is how I tried it originally. This did NOT work:

=IF(AND(C2=$O$1,(F2*$O$9)>G2),(F2*$O$4)*$M$16,G2*$M$16),IF(AND(B2=$O$1,(G2/$O$16)>F2),(G2/$O$3)*$M$16,F2*$M$16),IF(AND(B2<>$O$1,C2<>$O$1,(F2/$O$23)>(G2*$O$9)),(F2/$O$6)*$M$16,(G2*$O$4)*$M$16)))

Here is your version, which did work, and highlighting the parts that were missing from mine:

=IF(C2=$O$1,IF(AND(C2=$O$1,(F2*$O$9)>G2),(F2*$O$4)*$M$16,G2*$M$16),IF(B2=$O$1,IF(AND(B2=$O$1,(G2/$O$16)>F2),(G2/$O$3)*$M$16,F2*$M$16),IF(AND(B2<>$O$1,C2<>$O$1,(F2/$O$23)>(G2*$O$9)),(F2/$O$6)*$M$16,(G2*$O$4)*$M$16)))