9th July 2006, 03:05 PM
|
|
Member
|
|
Join Date: Jan 1970
Location: Sydney
Posts: 402
|
|
Quote:
|
Originally Posted by Mad Gambler
I'm trying to write a formula for recording the results of my top 2 selections.
These are the headings
Date
Venue
Race no.
Tab no.
e. Outlay
f. Return
g. Running bal.
My attempt is =f1-e1+g1
mad gambler
|
Your running balance looks wrong.
It should be something like
previous balance + f - e
One crude way of doing is the following expression in the g column:
=sum(F$1:F1) - sum(E$1:E1) |