Formula = Blank

[mariamagnvine]

I have this formula in my spreadsheet that looks at a value in another worksheet in the workbook and if it is I want it to be blank but it is putting in a zero (0). Can you tell me what might be incorrect?

<style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px 'Lucida Grande'; color: #000000}span.s1 {color: #005109}span.s2 {color: #9900cc}</style>=IF(IFERROR(MONTH3!B29,"")="",IF(IFERROR(MONTH2!B29,"")="",IFERROR(MONTH1!B29," "),IFERROR(MONTH2!B29,"")),IFERROR(MONTH3!B29,""))
[FONT=&quot]
[/FONT]

 

[MB110]

I think you can get around this problem by using the ISBLANK function. Just wrap your functions with it.

=IF(ISBLANK(IFERROR(Month1!B29,""))="",ISBLANK(IFERROR(Month23!B29,"")),"") ... and so on.