Many people find the process to cover up formula in OSHEET quite challenging, especially if they don't often deal with paperwork. Nevertheless, today, you no longer need to suffer through long tutorials or spend hours waiting for the editing software to install. DocHub allows you to edit documents on their web browser without installing new applications. What's more, our robust service provides a full set of tools for professional document management, unlike so many other online tools. That’s right. You no longer have to donwload and re-upload your forms so frequently - you can do it all in one go!
Whatever type of paperwork you need to modify, the process is easy. Take advantage of our professional online solution with DocHub!
what weamp;#39;re going to take a look at in this video is a really simple formula um that we can use to wrap around any formulas that we currently have in a sheet to automatically expand them into a new row that we put in um this obviously is a really simple sheet just to show you but if youamp;#39;ve got a big sheet with you know columns with 10 10 different Columns of all different formulas in it can be a real pain when you add new rows to then go down and keep copying the formula as as you go down and if you just take the formula and paste it all the way down the page to solve that problem then youamp;#39;ve got the issue of it looking messy it doesnamp;#39;t look very nice um you might have div errors all over the place um so weamp;#39;re just going to have a look at how to wrap a formula in something called an array formula um and how to make that just expand every time we put a new row in so what weamp;#39;re going to do here is weamp;#39;ve got um leads and sales and we