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?
@Rhonda Keller, SmartU How many times are users allowed to attempt the quizzes at the end of the self paced core path courses? I have had a few people at my company reach out to me stating that they are unable to retake the quizzes.
Have a samples request sheet that is populated by sales via a form. Once the shipment has been completed (triggered by date and tracking number input), the row is moved to an archive file and locked. Sales would like the ability to 'copy' previously archived rows, change dates (as well as automatically change the status,…
How do I show a timeline as a widget on the dashboard, not the programme breakdown with multiple rows. I am looking to represent a single row that represents the flow from one activity to the next so you can glance at it and see where we are and what's next. Thanks
