Try this:

=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:

simple formula j1-i1 but when I expand down the column I want it to return 0
or leave empty if a cell is blank. Can you help me?


--
Cheryl