View Full Version : Help Needed
Mad Gambler
9th July 2006, 12:09 PM
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
jfc
9th July 2006, 03:05 PM
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)
Raven
9th July 2006, 08:00 PM
i think that should be
=SUM($F$1:$F1)-SUM($E$1:$E1)
and drag that down the G column. should work
jfc
10th July 2006, 05:04 AM
i think that should be
=SUM($F$1:$F1)-SUM($E$1:$E1)
and drag that down the G column. should work
I think it's fine the way I wrote it. When aiming for simplicity over efficiency.
$E & $F expressions needlessly fix those columns. That can lead to problems if new columns are later inserted.
vBulletin v3.0.3, Copyright ©2000-2025, Jelsoft Enterprises Ltd.