If statements

[Tiffany]

I need a formula in Excel 2007 that says

=IF($A29=1),$B$2-$B$14*(C$16-$C$16)
or
(IF($A29=2),$B$2-$B$14*(E$16-$E$16)
Else
0

Kindly help

Thank you.

 

[Per Jessen]

HI

=IF($A29=1,$B$2-$B$14*(C$16-$C$16),IF($A29=2,$B$2-$B$14*(E$16-$E$16),0))

Regards,
Per

 

[Jacob Skaria]

This part of the formula always returns 0
(C$16-$C$16)

So
$B$14 * (C$16-$C$16) will always returns 0

Edit the below formula and use

=IF(A29=1,truepartif1,IF(A29=2,truepartif2,0))