sum formula that includes zero?

L

Lance

if(SUM(K15*J15)+(M15*L15),"")
is
if(SUM(K15*J15)+SUM(M15*L15),"")
or
if(K15*J15+M15*L15,"")


assuming that if the formula <> 0 then ""
is want you want and the word false if 0

or did you want

if(K15*J15+M15*L15>0,K15*J15+M15*L15,"")

Lance
 
Top