Have you ever had trouble with editing your Xls document while on the go? Well, DocHub has an excellent solution for that! Access this cloud editor from any internet-connected device. It enables users to Negate result in Xls files quickly and anytime needed.
DocHub will surprise you with what it provides you with. It has robust functionality to make any changes you want to your forms. And its interface is so intuitive that the entire process from beginning to end will take you only a few clicks.
As soon as you finish adjusting and sharing, you can save your updated Xls file on your device or to the cloud as it is or with an Audit Trail that contains all adjustments applied. Also, you can save your paperwork in its original version or transform it into a multi-use template - complete any document management task from anywhere with DocHub. Subscribe today!
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