Cell to be 0

[Blackwell]

Hello,

I have this formula =IF(E11="","",SUM(F6:M6,B11:E11)) which works, but the cell the formula appears in is E15 What i am trying to do is that if cell E11 have no value in then cell E15 to be "0", the formula I have works when E11 has a value in it adds to E15 ok. But I need E15 to be blank or 0 if e11 has no value in. I hope T have explain this ok.

 

[mole999]

Is =IF(E11="","",SUM(F6:M6,B11:E11)) in E15 ?

 

[MARK858]

A bit strange question as your formula puts in an empty string ("") which would appear as a blank (not actually blank) if E11 was empty.
If you want a zero then it would be

=IF(E11="",0,SUM(F6:M6,B11:E11))

 

[Blackwell]

Hi, yes E15 is the cell where the formula is. If cell E11 is empty, then I want E15 to return 0 or blank.