Thread: SUMIF
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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++