IFERROR

ssanchez

HI all,

I have a sheet where I am collecting data. One is our overall variance. In certain rows I do not have data and receive the #DIVIDE BY ZERO message. I have attached the screenshot to show my formula.

Thank you,

Mike Wilday

Hi there, the issue is that your IFERROR doesn't have an open parenthesis. IF should be IFERROR( your formula , value if error). 

=IFERROR([Comulative Cost]1-[Cumulative Budget]1/[Cumulative Budget]1, 0)

But you should also consider using @row instead of declaring the row number so its easier to copy/paste between rows. 

=IFERROR([Comulative Cost]@row-[Cumulative Budget]@row / [Cumulative Budget]@row, 0)

Mike Wilday

It also looked like you were closing the error early in the calculation which would also cause an issue. Your entire calculation should be enclosed in there. 

Mike Wilday

Did you ever get this working?