Using IFERROR Formula - Still getting UNPARSEABLE error

Christine Cao
Christine Cao ✭✭
edited 06/30/23 in Add Ons and Integrations

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")

Best Answer