Cell Value to be blank

In cells A2 & B2 I have =iferror((forumual),"0"). The issue I'm having here is that I want the cells to show nothing but cant have my iferrorr return a value of "". This is because in cell C3 I have =sum(A2+B2) and this wont work unless the cells have a value of 0. I've tried to custom format the cell with 0;;;@ but I'm still seeing a value of 0 in my cells. Is there another method I can use for cells A2 & B2 to show as blank?

Originally Posted by MrShorty

This is a case where you may need to carefully define what you mean by "blank".

To my knowledge, there is no way for a formula to return the equivalent of a blank cell.
I am a little surprised that your number format 0;;;@ failed. Your sample formula =iferror((forumual),"0") has quotation marks around the 0, making it a text string. Where your number format tells Excel to not display 0 numbers, it allows Excel to display numbers stored as text, which is what your formula would return. Perhaps all you need to do is drop the quotation marks so you return the number 0 and not the text string "0".

I always figured that you needed "" for iferror to get the desired value. I didnt know that "" changes the format of the value. Thank you the insight and helping me out with this.