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.

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

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

To add 2.20% use *1.022

If you find this confusing you could use a formula like

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

This may not be the answer to your current problem but it's worth saving for future ref. click here

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

AMD Ryzen news - release date, UK price, features and specifications

The 12 best apps for drawing and painting on your iPad

Mac power user tips and hidden tricks

Comment faire des captures d’écran sous Windows 10 ?