Formula issues getting blank rather than zero

[Detectiveclem]

What am I doing wrong

I am using this formula in cell E7 successfully =IF(D7-C7<0, 1+D7-C7, D7-C7).

But when cell C7 has no data I do NOT want ‘0’ to appear in E7. I have tried various formulas including this one =IF(C7=””,””,D7-C7<0, 1+D7-C7, D7-C7) but it doesn’t work.

Can someone please help me rectify the formula so that cell E7 remains blank until data is entered in C7.

Thank you

 

[SQUIDD]

try this

=IF(C7="","",IF(D7-C7<0, 1+D7-C7, D7-C7))

if i understand correctly

dave

 

[Peter_SSs]

Another possible option.

=IF(C7="","",D7-C7+(C7>D7))

 

[Detectiveclem]

Thank you Squidd and Peter, both formulas work perfectly.

However I now get an ERROR in another of my formulas =SUM(E7+H7+K7) after I have copied your formula into E7,H7 & K7. Can you assist further? Thank you Paul

 

[SQUIDD]

=if(e7="",0,e7)+if(h7="",0,h7)+if(k7="",0,k7)

 

[Fluff]

Another option
=SUM(E7,H7,K7)

 

[Detectiveclem]

Hi again Squidd, this solves the ERROR however it returns a zero into the cell and I want it to remain blank. I can not use the option of not displaying zeros as a default as other cells need to show when an actual zero '0' has been entered. How can I tweak your format to achieve this? Thanks again. Paul

 

[Detectiveclem]

Hi Fluff, thank you but as you'll see from my other posts I am trying to achieve a blank cell rather than having zeros.

 

[Fluff]

In that case how about
=IF(SUM(E7,H7,K7)=0,"",SUM(E7,H7,K7))

 

[SQUIDD]

not at my pc right now, perhaps

i think fluff has it