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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Want To Shrink Formula 1
OMIT BLANK LINES WHEN FORCING A CARRIAGE RETURN --- PLEASE HELP! 5
How do I nest these 3 IF functions? 4
Subtracting Dates with Empty Cells 3
Excel auto calculation formula question. 7
could not find title 1
A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED 7
Formula not working for me now 2

Top