Time is an important resource that every business treasures and attempts to turn into a benefit. When selecting document management software, focus on a clutterless and user-friendly interface that empowers customers. DocHub offers cutting-edge features to optimize your document management and transforms your PDF file editing into a matter of one click. Hide Calculations in the Product Defect Notice with DocHub in order to save a lot of efforts and improve your productivity.
Make PDF file editing an simple and intuitive process that helps save you plenty of valuable time. Quickly adjust your files and deliver them for signing without the need of adopting third-party options. Give attention to relevant duties and increase your document management with DocHub today.
in this video Im gonna talk a little bit about how you can hide / 0 errors but using the if function thats just one possible way you can do it you know there are other methods in fact Ive posted a video a few years ago about using the if error function to be able to deal with with divide by zero and in other errors too but its always good to know more than one way to solve a problem so today were going to look at using the if function so here weve got just the simple table here where we have the year 1 sales your to sales and weve calculated the dollar change and the percent change but for one of these items since there were no sales in year 1 we inherently have it divided by zero error no way we can avoid that so no one wants to see an error message locked out on report so we need to find some way to to deal with it so lets copy these down and so were gonna edit or make a different formula here for our percentage change so instead of just dividing d8 by b8 lets take that out