Not sure if I get the question but try =IF(OR(A1=0,B1=0),0,A1-B1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
"Silvercreek" wrote in message
...
I use the MAX command for negative numbers when a positive number is
subtracted from zero or empty cells, returning a negative number, but that
does not work when subtracting zero or empty cells from a positive cell.
Is
there a formula that will return a zero if either of the values in any of
the
cells being subtracted is empty or a formula that would cover both
situations?
Thanks
--
Silvercreek