Using IFERROR Formula - Still getting UNPARSEABLE error

Christine Cao

I'm calculating a Burn Rate Percentage so it's using a basic calculation

FORMULA =[Column4]@row / [Column2]@row --> This works fine

However when one of the Column is a ZERO, I get a #DIVDE BY ZERRO error displayed. To address this error, I used an IFERROR but it's giving me an "UNPARSEABLE" error. I want the cell to display "NO DATA" if there's a zero in one of the column used. Seems simple enough but...

What's wrong with this current formula I have?

=IFERROR([Column4]@row / [Column2]@row), "NO DATA")

Paul Newcome

You need to remove the closing parenthesis from before the comma.

Paul Newcome

You need to remove the closing parenthesis from before the comma.

Christine Cao

@Paul Newcome - thank you so much Paul. That worked.

Paul Newcome

Happy to help. 👍️