How to get a number show up as 0 inside a formula.

Originally Posted by Glenn Kennedy

iferror(if(your formula=0,"--",your formula),"--")

Separate the ifferror bit from the index match bit and use the above structure. You'll get an -- for zeros and for errors.

I keep getting too many errors for this function when trying this, any chance you could type it out for me so I can paste it in how it should look? Thanks!