Having full control of your documents at any moment is crucial to ease your everyday duties and boost your efficiency. Accomplish any goal with DocHub features for document management and hassle-free PDF file editing. Access, adjust and save and integrate your workflows with other secure cloud storage services.
DocHub gives you lossless editing, the chance to work with any formatting, and safely eSign papers without looking for a third-party eSignature option. Make the most of your file managing solutions in one place. Consider all DocHub capabilities today with the free of charge account.
alright so in this video Im gonna show you how to create an array formula that will give you an effect of automatically dragging down your formulas so youll see what I mean in a second so usually when we make formulas seen our spreadsheets like in Google sheets we go here for example lets say I have sales and I have quantity maybe I want to divide my sales by quantity to get some number thats gonna be per piece so the formula doesnt matter here so much the idea here if I did an equal sign I could say take this sales number divided by this quantity number and if I enter thats gonna give me whatever thats supposed to be and if I take that number and if I drag this down it will just basically give me all of these for all of these rows at the same time now let me just convert this to currency really quickly here so what I want to do I want this to work as we add more data I want this to just automatically drag down this formula so that Im gonna do using an array formula so what I