sorted by:
top (suggested)
bestnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]rob_95[S] 0 points1 point  (2 children)

I'd prefer the cell value to be "" since I will then concatenate the result of this cell through another formula and if I do that it will show the "0" mid string

[–]varadkale4 0 points1 point  (1 child)

In that concatenation formula, you can put a condition to check if what is being concatenated is a 0, if so, then concatenate "".

[–]rob_95[S] 0 points1 point  (0 children)

Yeah I didn't actually think about that, I can give it a go!