Thread: Two Formulas in one

I'm trying to combine these two formulas but can't seem to get it to work.

=IF(AND(A32="x",B32="US"),I32*$D$89*$F$89,0)=IF(AND(A32="x",B32="CDN"),I32*$F$89,0)

Basically, if there is NO "X" placed in a cell, i'd like the result to be zero.

IF there is an X placed in the cell, I need it to read if its US or CDN and if so, I need it to react differently for both.

D89 is the exchange rate
F89 is the markup that i'm selling my product for.

I'm basically trying to make a form that I can fill out when a customer orders something from me (kind of Purchase Order type of thing) and I want to give the customer a total right away.

Any help in combining this or fixing this formula would be GREATLY appreciated!!!

Try: =IF(A32="x", I32*$F$89*IF(B32="US", $D$89, 1), 0)