This works for empty or zero cells, in Excel, that would return a positive
when subtracted from a positive cell, but not when positive cells are
subtracted from zero or empty. Can this be tweaked a bit?
Thanks for your help

--
Silvercreek


"Bernard Liengme" wrote:

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