[email protected]® 18:16 22 May 2004
Locked

I want to do a simple spreadsheet to keep track of a couple of bills. For example in column A is the company, column B is the balance, column C is amount paid, column D is date paid and column E is closing balance. How do I do this and what formula would I use. Thanks

Daz

VoG II 18:32 22 May 2004

I assume that you have headings in Row 1 so I'll assume the data starts at Row 2.

In E2 enter the formula

=B2-C2

and press Enter.

Hover the cursor over the bottom right of cell E2 until the cursor turns into a +

Press and hold the left mouse button and drag down to copy the formula down the page as far as you wish.

In B3 enter the formula

=E2

then copy down the page as before.

[email protected]® 18:57 22 May 2004

Thanks Vog, now I am probably getting ideas above my station! On one of them I need to add 5.0% interest on to the closing balance. How hard is this? Thanks

VoG II 19:02 22 May 2004

By "on one of them" I assume that you mean a particular company, let's call this "PCADVISOR" for the sake of example. Then you would modify the formula in E2 above to

[email protected]® 19:10 22 May 2004

With the *1.05 for 5.0% how do I work out other amounts i.e 2.20% etc. Thanks

pcwhizz 19:14 22 May 2004

Right,

To add 5% you would have to use this formula

=0.05*(B2-C2)+(B2-C2)

put this into cell E2 then as VoG sed above get the little cross and drag down to it to all of your columns.

If you only want one bill to add 5% you will have to change the cell references from B2-C2 (IN BOTH BRAKCETS) to

B3-C3
B4-C4
B5-C5

And so on.

soz if ive confuse you

pcwhizz

VoG II 19:16 22 May 2004

If you find this confusing you could use a formula like

[email protected]® 19:36 22 May 2004

Thank you both for your help, I think I have sussed it. I am sure you will help me again if I encounter any problems.

Cesar 10:06 23 May 2004