Excel formulas in a column

%3CLINGO-SUB%20id%3D%22lingo-sub-3082482%22%20slang%3D%22en-US%22%3EExcel%20formulas%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3082482%22%20slang%3D%22en-US%22%3E%3CP%3EIs%20there%20a%20%22universal%22%20formula%20can%20I%20use%20that%20will%20work%20in%20each%20cell%20in%20the%20balance%20column%20with%20this%20document%3F%20I'm%20pretty%20new%20to%20this%2C%20so%20don't%20know%20how%20to%20do%20this%20other%20than%20to%20keep%20entering%20the%20formula%20edited%20for%20each%20cell%20individually%20so%20that%20the%20balance%20is%20calculated%20correctly%20each%20time.%20Thanks!%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22petty%20cash%20formula%20in%20excel.jpg%22%20style%3D%22width%3A%20636px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F343430i41A79A425EEBF095%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22petty%20cash%20formula%20in%20excel.jpg%22%20alt%3D%22petty%20cash%20formula%20in%20excel.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3082482%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3082543%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formulas%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3082543%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20just%20copy%20that%20formula%20down%20the%20column%20it%20will%20do%20what%20you%20want.%20Edit....Copy%20when%20your%20cursor%20is%20in%20cell%20B4%2C%20then%20Edit%20Paste%20in%20all%20rows%20below.%20%26nbsp%3BThat's%20all%20I%20did%20in%20the%20attached%20demo%20file.%20There%20is%20absolutely%20no%20need%20to%20re-type%20the%20formula%20each%20time.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EYou%20should%20familiarize%20yourself%20with%20a%20good%20reference%20website%20for%20basic%20Excel.%20Here's%20but%20one.%20%3CA%20href%3D%22https%3A%2F%2Fexceljet.net%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noreferrer%22%3Ehttps%3A%2F%2Fexceljet.net%3C%2FA%3E%20You%20could%20also%20check%20out%20basic%20videos%20on%20YouTube%3CBR%20%2F%3E%3CBR%20%2F%3EThere%20are%20many%20others.%20A%20basic%20book%20(e.g.%2C%20Excel%20for%20Dummies)%20is%20also%20a%20good%20investment.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3082808%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formulas%20in%20a%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3082808%22%20slang%3D%22en-US%22%3EThanks%20very%20much%20for%20all%20the%20info.%20I%20will%20check%20out%20those%20resources.%20But%20for%20today%2C%20I%20really%20need%20to%20get%20this%20fixed%2C%20and%20realize%20it%20must%20be%20frustrating%20to%20help%20someone%20new%20to%20this.%20I%20don't%20see%20a%20demo%20file%2C%20and%20nothing%20I%20clicked%20on%20appeared%20to%20be%20that...is%20it%20a%20video%3F%20If%20I%20copy%20the%20formula%20in%20the%20first%20cell%2C%20do%20you%20mean%20I%20then%20paste%20that%20same%20formula%20in%20every%20cell%20in%20the%20column%2C%20and%20it%20will%20automatically%20change%20the%20formula%20for%20each%2C%20or%20is%20there%20a%20way%20to%20apply%20that%20universally%20to%20all%20in%20one%20fell%20swoop%3F%3C%2FLINGO-BODY%3E
New Contributor

Is there a "universal" formula can I use that will work in each cell in the balance column with this document? I'm pretty new to this, so don't know how to do this other than to keep entering the formula edited for each cell individually so that the balance is calculated correctly each time. Thanks!petty cash formula in excel.jpg

4 Replies

If you just copy that formula down the column it will do what you want. Edit....Copy when your cursor is in cell B4, then Edit Paste in all rows below.  That's all I did in the attached demo file. There is absolutely no need to re-type the formula each time.


You should familiarize yourself with a good reference website for basic Excel. Here's but one. https://exceljet.net You could also check out basic videos on YouTube

There are many others. A basic book (e.g., Excel for Dummies) is also a good investment.

Thanks very much for all the info. I will check out those resources. But for today, I really need to get this fixed, and realize it must be frustrating to help someone new to this. I don't see a demo file, and nothing I clicked on appeared to be that...is it a video? If I copy the formula in the first cell, do you mean I then paste that same formula in every cell in the column, and it will automatically change the formula for each, or is there a way to apply that universally to all in one fell swoop?

@Snoozin28 

 

You don't see this at the bottom of my reply? That "basicAdding.xlsx" is an Excel file. Click on the black down pointing arrow to download it. But all it contains is the formula and a few dummy pieces of data. The main point is that I just did a mass copy....paste.

mathetes_0-1643402087693.png

 

You wrote:  If I copy the formula in the first cell, do you mean I then paste that same formula in every cell in the column, and it will automatically change the formula for each, or is there a way to apply that universally to all in one fell swoop?

 

Yes. It will adjust itself for every cell going down. You do a mass copy/paste, one time.

Thank you for all your input!