Using IFERROR Formula - Still getting UNPARSEABLE error
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
-
You need to remove the closing parenthesis from before the comma.
Answers
-
You need to remove the closing parenthesis from before the comma.
-
@Paul Newcome - thank you so much Paul. That worked.
-