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?
I have an automation set up to email certain team members if values change on a sheet. The trigger is set to Daily so that it doesn't send them a bunch of emails every time I add data. What I want to know is, at what time do these usually run? I want to make sure that it is not sending out the email before I have finished…
What is a formula to count the # of tasks that are overdue, based on a date?
Hi everyone, I have a sheet that has various steps for people to complete. As they complete their task, the date is recorded that it is completed. What I would like to show is most recent date of completed so that I can show the last step completed date and then what the last step completed was (the column title of the…
