C
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?
or leave empty if a cell is blank. Can you help me?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JBeaucaire
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "")
=IF(COUNTA(I1:J1)=2, J1-I1, "")
J
JBeaucaire
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "")
=IF(COUNTA(I1:J1)=2, J1-I1, "")
J
JBeaucaire
This should work for you.
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "")
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "")
J
JBeaucaire
Try this:
=IF(COUNTA(I1:J1)=2, J1-I1, "")
=IF(COUNTA(I1:J1)=2, J1-I1, "")
E
Eduardo
Hi,
=if(or(i1="",J1=""),"",J1-I1)
=if(or(i1="",J1=""),"",J1-I1)