Today’s document management market is huge, so locating the right solution meeting your needs and your price-quality expectations can be time-consuming and burdensome. There’s no need to waste time browsing the web looking for a universal yet simple-to-use editor to Negate formula in Excel file. DocHub is here to help you whenever you need it.
DocHub is a globally-known online document editor trusted by millions. It can satisfy almost any user’s request and meets all necessary security and compliance standards to ensure your data is well protected while modifying your Excel file. Considering its powerful and intuitive interface offered at a reasonable price, DocHub is one of the best choices out there for enhanced document management.
DocHub provides many other features for successful form editing. For instance, you can turn your form into a re-usable template after editing or create a template from scratch. Discover all of DocHub’s features now!
hi Im Ted today Im going to show you how to display positive values only in a formula in Excel I have a spreadsheet all set up here and I have two columns of numbers what Im calling a what Im calling be not a very exciting list but it should get the point across and I have a column where Im going to calculate the difference a minus B and Im going to show you how you can display the positive values only so the first thing well do is well put in a formula its just equals and we click over here on a to minus b2 just click on that hit return and theres the theres the result and what we want to do is copy that formula down to all the other cells so click on the cell move the cursor till it turns to a solid plus sign and drag it down thats a very convenient way of copying a formula in two different cells and we see that some of the differences are negative and what we want to do is do something where we only display the positive values so the best way I know of to do this is to i
