Sign in to join the conversation:
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,
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)
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.
Did you ever get this working?
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…
Hi everyone, hoping for a little help here, I recently did a survey of 240 employees with 9 yes or no questions. I am hoping to create either a linebar or stacked linebar graph showing the 9 questions in a single chart with the question being on the left axis. When I try to do a report to create this graph, Im unable to…
I have given someone access as an Admin to allow them to create new sheets and edit existing and they keep being told they do not have access to edit. What could be causing this?
