Enter zero in multiple columns

[MB_Rocks]

Hi 

Can someone help in inserting zero in multiple columns. I'm using multi field formula but its not happening.

Problem statement:

Where ever column in null/blank need to add zero where ever have values need to remain as it 

Here I have attached a dummy sheet as well .Please help 

[JarekSkudrzyk · Accepted solution]

@MB_Rocks 

Hi,

please find the solution attached. If this solves your problem please consider marking my answer as a solution.

regards

[MB_Rocks]

@JarekSkudrzyk Thanks a lot 

[JarekSkudrzyk]

@MB_Rocks you are welcome!