Please help with formula

[firstWeMeet]

Hello forum, just looking for help with this formula.
I have row1 which: C1 formula is =SUM(A1+F7-G7) and I want to maintain the cell format like this

but when A1,F7,G7 has no numbers C1 showing "0" I want C1 just show blank cell when the A,F,G1 is 0 number, note that F1 and G1 has a formula too.

 

[diddi]

=if(and(A1<>0,F7<>0,G7<>0),SUM(A1+F7-G7),"")

 

[Michael M]

try

=IF(AND(A1="",F7="",G7=""),"",SUM(A1+F7-G7))

 

[firstWeMeet]

Thanks, working here.

 

[diddi]

@MM too slow. get a faster pidgeon. LOL

 

[Michael M]

Hi P.......that's as fast as I can pedal !!

 

[diddi]

you should get on the NBN!

 

[firstWeMeet]

How if a multiple cell like in row1 AF1 formula is =SUM(A1,C1,E1,G1,and many more. the if AF1 = 0 should show blank.

 

[truskawa]

Not sure if I understand right: but this should work:
AF1:
=IF(SUM(A1,C1,E1,G1,and many more)=0,"",SUM(A1,C1,E1,G1,and many more))

 

[firstWeMeet]

Do I need to put all cells? cause cells is about 50+ cells so formula will take longer, I am wondering about this formula but not working
since the formula located at AF1
=IF(AF1>0,SUM(A1,C1,E1,G1,and many more),"") but this is not working