SUMIF
 

i do HATE MShelp

if cell d17 has something in it (0) i want to subtract c17-d17 or add c17
and -d17

please help! i could do it in C++

SUMIF
 

Try the below

=IF(D170,C17-D17,C17+(-D17))

OR
=IF(D17="","",C17-D17)

If this post helps click Yes
---------------
Jacob Skaria


"jmfozzybear" wrote:

i do HATE MShelp

if cell d17 has something in it (0) i want to subtract c17-d17 or add c17
and -d17

please help! i could do it in C++

SUMIF
 

Are you sure you mean that, Jacob?

Isn't C17-D17 the same as C17+(-D17) ?
--
David Biddulph

"Jacob Skaria" wrote in message
...
Try the below

=IF(D170,C17-D17,C17+(-D17))

OR
=IF(D17="","",C17-D17)

If this post helps click Yes
---------------
Jacob Skaria


"jmfozzybear" wrote:

i do HATE MShelp

if cell d17 has something in it (0) i want to subtract c17-d17 or add
c17
and -d17

please help! i could do it in C++

SUMIF
 

I dont think OP is quite good with IF(). I just put in that to show the IF
statement ...Didnt you see the second formula...

If this post helps click Yes
---------------
Jacob Skaria


"David Biddulph" wrote:

Are you sure you mean that, Jacob?

Isn't C17-D17 the same as C17+(-D17) ?
--
David Biddulph

"Jacob Skaria" wrote in message
...
Try the below

=IF(D170,C17-D17,C17+(-D17))

OR
=IF(D17="","",C17-D17)

If this post helps click Yes
---------------
Jacob Skaria


"jmfozzybear" wrote:

i do HATE MShelp

if cell d17 has something in it (0) i want to subtract c17-d17 or add
c17
and -d17

please help! i could do it in C++


.