This should work for you:

=IF(COUNTA(I1:J1)=2, J1-I1, "")

--
"Actually, I *am* a rocket scientist." -- JB
(www.MadRocketScientist.com)

Your feedback is appreciated, click YES if this post helped you.


"Cheryl" wrote:

I have a simple formula in column k...=j2-i2....I want to expand it down the
column but if one of the cells is empty I want it to just leave it blank or
return a zero. Can someone tell me how to do this please?

Thanks!
--
Cheryl