simple sum unless blank

[Cheryl]

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?

 

[JBeaucaire]

Try this:

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

 

[JBeaucaire]

Try this:

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

 

[JBeaucaire]

This should work for you.

Try this:

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

 

[JBeaucaire]

Try this:

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

 

[Eduardo]

Hi,

=if(or(i1="",J1=""),"",J1-I1)