Excel Spreadsheets

i know how to do it

:D please go on...

click on the bottom right of the box, there should be a darker arrow

then draaaaaaaag

hope this makes sense

nonshy il tell you how if u tell me those websites in which i can get info on team news in lower leagues ;)

TY rictus... if i wanted a third column to show actual amount required to achieve daily target what would that formula be?

master of multies... i don't deal in second rate football!! :-)

3rd column? You've only got one so far haven't you?

=a2-a1 ?

And then draaaaaaaaggg ?

formula in first column isn't right... want 1% of balance... currently got =B3*1.01 (draaaaag)

but how do i get that to show for 365 days without inputting it manually?

Try it for 4 days first as a trial.

:-)

:D

This is what I am trying to achieve to start with!!!

Starting bank: £500... making 0.5% a day

Column1 --------- Column2 ----------------Column3

Day 1-------------- £502.50 ------------------ £2.50
Day 2-------------- £505.01 ------------------ £2.51
Day 3--------------- £507.54 ------------------ £2.53

etc etc

This is what I am trying to achieve to start with!!!

Starting bank: £500... making 0.5% a day

Column1 --------- Column2 ----------------Column3

Day 1-------------- £502.50 ------------------ £2.50
Day 2-------------- £505.01 ------------------ £2.51
Day 3--------------- £507.54 ------------------ £2.53


So put 500.00 in cell B1
Day 1 in cell A2 - draaaaag
=B1*1.005 in cell B2 - draaaag
=B2-B1 in cell C2 - draaaaag

THANKS!!!!

Very much appreciated!!!