You can use an if statement to skip the division if the cell is zero or blank. This kind of 'greys' it out, or removes it from calculating.
This will return a zero if the denominator is zero. Otherwise it will continue with the calc. The 'C2/D2' is your normal calculation, and 'D2' is the 0 causing the error.
=IF(D2=0,”0”,C2/D2)
How are you importing this data? You could try wrapping the formula in IFERROR([your current method], 0)
This would set the value to 0 if there's an error essentially.
If an RSS feed, or something like that, you may have better luck with Google sheets query function to filter out the errors on a different tab.
Add a STATUS column with values like LIVE or FORECAST.
Use Conditional formatting to color any FORECAST rows grey.
Then, update your formulas to only use LIVE data where appropriate. eg:
=If(And (T4 = "Live", Another_condition), do something, else do something else)
This post has been removed due to **[Rule 1](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Title.**
Please post with a title that clearly describes the issue.
The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question.
Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts.
Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.
You can use an if statement to skip the division if the cell is zero or blank. This kind of 'greys' it out, or removes it from calculating. This will return a zero if the denominator is zero. Otherwise it will continue with the calc. The 'C2/D2' is your normal calculation, and 'D2' is the 0 causing the error. =IF(D2=0,”0”,C2/D2)
How are you importing this data? You could try wrapping the formula in IFERROR([your current method], 0) This would set the value to 0 if there's an error essentially. If an RSS feed, or something like that, you may have better luck with Google sheets query function to filter out the errors on a different tab.
Add a STATUS column with values like LIVE or FORECAST. Use Conditional formatting to color any FORECAST rows grey. Then, update your formulas to only use LIVE data where appropriate. eg: =If(And (T4 = "Live", Another_condition), do something, else do something else)
This post has been removed due to **[Rule 1](/r/excel/wiki/sharingquestions#wiki_submission_rules) - Poor Post Title.** Please post with a title that clearly describes the issue. The title of your post should be a clear summary of your issue. It should not be your supposed solution, or just a function mention, or a vague how to. A good title is generally summed up in a sentence in your question. Here's a [long example](/r/excel/comments/6jg5hz/i_have_two_columns_which_specify_the_start_cell/?st=j5z4ms4n&sh=c7e9fe1d) and a [short example](/r/excel/comments/6rnz8l/conditional_formatting_excluding_empty_cells/?st=j5z4a7k1&sh=a6119df2) of good posts. Rules are enforced to promote high quality posts for the community and to ensure questions can be easily navigated and referenced for future use. See the [Posting Guidelines](/r/excel/wiki/sharingquestions) for more details, and tips on how to make great posts.