DocHub is an all-in-one PDF editor that lets you rub out result in excel, and much more. You can underline, blackout, or remove paperwork fragments, insert text and images where you want them, and collect data and signatures. And since it runs on any web browser, you won’t need to update your device to access its professional tools, saving you money. With DocHub, a web browser is all you need to manage your excel.
Log in to our website and follow these instructions:
It couldn't be simpler! Improve your document management today with DocHub!
hi Iamp;#39;m Ted today Iamp;#39;m going to show you how to display positive values only in a formula in Excel uh I have a spreadsheet all set up here and I have two columns of numbers one Iamp;#39;m calling a one Iamp;#39;m calling B not a very exciting list but it should get the point across and I have a column where Iamp;#39;m going to calculate the difference a minus B and Iamp;#39;m going to show you how you can display the positive values only so the first thing weamp;#39;ll do is weamp;#39;ll put in a formula and itamp;#39;s just equals and we click over here on A2 minus B2 we just click on that hit return and thereamp;#39;s the thereamp;#39;s the result and what we want to do is copy that formula down to all the other cells so click on the cell uh move the cursor till it turns to a solid plus sign and drag it down thatamp;#39;s a very convenient way of copying a formula to different cells and we see that um some of the differences are negative and we what we want to