basic microsoft excel question?

Question

I'm setting up basic spreadsheet to help me track my finances. I'm a novice at excel, but I've figured out how to get the columns to total up. What I need to know is the formula or function to get my grand total outgoing funds to subtract from my grand total incoming funds. Anyone got any ideas?

Answer 1

sum(grand total incoming cells) - sum(grandtotal outgoing cells)

Answer 2

VBA and Microsoft Excel are no longer interchangeable technologies. VBA is a scripting language used to automate administration of the purposes of its host application (any of the microsoft workplace kit, which is composed of Excel). Excel is a spreadsheet application which could be changed and controlled with the help of a VBA script. in case you're able to desire to make a application to do something at once, you're able to desire to write it in VBA. It looks such as you in easy terms desire a spreadsheet and a few purposes to calculate a quote, which does no longer require a VBA application except you desire to create your individual interface.

Answer 3

Since I am not exactly sure what you are looking for, I will suggest you use a template to make your spread sheet. A template is a workbook that someone else has already created for the job you need. These are hundred of these at the Microsoft site (and they are all free!) that you can browse.
Open up Excel and create a new work book. In the task pane on the right hand of the screen, which should say "New Workbook, " choose under templates either option (from my computer or online). Or you may want use the search function.

If you can't see the task pane, press "control" and the "f1" keys at the same time and it should appear.

There is a really good checkbook template available there that I use to keep track of my accounts. For the first time in my life, my finances are accurate! Let me know if I you need more help. The template link is below if you can't get to it via Excel.

Answer 4

=(cell1-cell2)

ie, cell1 is the cell number of your total outgoing
and cell2 is your totall incoming

example :
=(B19-C19)