If statements
 

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.

If statements
 

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

"Tiffany" skrev i meddelelsen
...
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.

If statements
 

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))

--
Jacob


"Tiffany" wrote:

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.