Help With Microsoft Excel

[Paddington]

I'm at work on my paid vacation and I'm bored so I'm trying to help out with this one thingy.

Spreadsheet.
Vertical columns have the date and a letter for the blank columns.
Horizontal columns have the money totals by department and a number for blank columns.
There are little tabs on the bottom. 5 of them. 'Week 1' 'Week 2' etc.
The idea is to create a 6th tab for a 6th week of this great month of November. (Seriously.)
Then the idea is to make it into week 5 and make the current week 5 into week 6.

[MithLuin]

The tabs are for separate worksheets, yes?

So, right-clicking on it should give you the option of making a new (or more appropriately, duplicate) worksheet.

Then, you simply edit the name of one of them to say "week 6"


Does that help?

[N/A Gone]

I use excel as my checkbook. I have a page where I have the debt and the deposits. I want the column to the right to give me a running total. How would I work that equation?

[ardillacid]

I am a level 73 excel wizard.

[mommas_boy]

[quote name='Revprodeji' date='10 December 2009 - 12:04 PM' timestamp='1260464651' post='2017538']
I use excel as my checkbook. I have a page where I have the debt and the deposits. I want the column to the right to give me a running total. How would I work that equation?
[/quote]

So, you have a column for credits (deposits), say Column "A"? And a column for debits (what you spend), say Column "B"? You want Column "C" to be the running total. Is that correct?

So, you want it to look like this:

[code]
A B C
---- -- ----
1: 1000 1000
2: 10 990
3: 20 970
4: 30 940
5: 500 1440
6: 40 1400
7: 100 1300
[/code]


Select cell C1. Input the following:

[code]
=A1-B2
[/code]

You should get 1000 in C1.

Then, select cell C2. Input the following:

[code]
=C1+A2-B2
[/code]

A little black square will be in the lower right corner of that cell. Click the square, and drag it all the way down. That is your running total.

[mommas_boy]

Also, @ Rev: if you want to spend less time balancing your checkbook, and more time managing your finances, then I would highly recommend www.quickenonline.com. [b]It's free[/b], and it takes care of all of the filling-in stuff, and automatically makes graphs and so forth to help you track where your money is going. I find that it gives me more time to manage my money, rather than filling in the checkbook. Though, some people like the practice of filling in the checkbook (they feel like they can better watch their money), so I can understand that too.

Edited December 10, 2009 by mommas_boy

[N/A Gone]

Thanks, but I am using my phone so the excel works great.

My Dad was a big business corp guy, so I have used all those softwares. (no spam) I do some independent marketing that requires me to track business expenses also. (www.timetoshop.org) I will check out that site and see if I can use it, but I like the excel program I use.

[mommas_boy]

[quote name='Revprodeji' date='10 December 2009 - 02:29 PM' timestamp='1260473370' post='2017687']
Thanks, but I am using my phone so the excel works great.

My Dad was a big business corp guy, so I have used all those softwares. (no spam) I do some independent marketing that requires me to track business expenses also. (www.timetoshop.org) I will check out that site and see if I can use it, but I like the excel program I use.
[/quote]

Cool. Definitely use what works best for you. The free online version of Quicken really isn't all that great for managing the separate finances of a business, so it sounds like separate excel sheets work better for you, and are also phone portable.

Did the above formula work for you?

[Paddington]

Well, I accomplished my goal.

I really messed up by deleting a week's worth of something, but yea, the goal still happened.

[XIX]

[quote]
A little black square will be in the lower right corner of that cell. Click the square, and drag it all the way down. That is your running total.
[/quote]
A little shortcut: If you double-click the little black square, it will automatically fill in the formula from the selected cell all the way down to the bottom of your data (until there is a break in the data).

[quote]A B C
---- -- ----
1: 1000 1000
2: 10 990
3: 20 970
4: 30 940
5: 500 1440
6: 40 1400
7: 100 1300[/quote]

So in your example, filling a formula in C1, selecting C1 and double clicking the black box in the corner of the selected cell would copy the formula down to C7.

This is extremely useful in large sheets where you may have thousands of rows of data.

[N/A Gone]

I actually have the debt and the additions in one column. Just because it is on my phone and easier to read. (The debt is red, etc) could you modify the formula for me please?

I really appreciate it.

[mommas_boy]

Assuming that debits are denoted from credits by a negative sign ... you want credits/debits in column A, and running total in column B:

[code]
A B
----- -----
1: 1000 1000
2: -100 900
3: -24 876
4: 500 1376
[/code]

In cell B1, input:

[code]
=A1
[/code]

In cell B2, input:

[code]
=B1+A2
[/code]

And then drag, or double click.

The only way that this works is if you denote debits with a negative sign so that it "adds" a negative.

Edited December 11, 2009 by mommas_boy

[ardillacid]

[quote name='Paddington' date='10 December 2009 - 06:28 PM' timestamp='1260487736' post='2017951']
Well, I accomplished my goal.

I really messed up by deleting a week's worth of something, but yea, the goal still happened.
[/quote]
ctrl z

[Paddington]

[quote name='notardillacid' date='11 December 2009 - 08:10 PM' timestamp='1260576601' post='2018698']
ctrl z
[/quote]

Thank you Doctor Squirrel.

[MIKolbe]

=IF(C1540<20.01,"300+",IF(C1540<35.01,"175+",IF(C1540<50.01,"150+",IF(C1540<80.01,"75+",IF(C1540<115.01,"50+",IF(C1540<200.01,"35+",IF(C1540<500.01,"25+","15+")))))))


THAT'S WHAT I'M TALKIN' 'BOUT!!!!!!!