Add value as changes

S

Schubawi

Team Played Won Lost Draw Bonus Points Total
Blues 0 1 0 0 0 0
Western Force 0 1 0 0 0 8
Crusaders 0 1 0 0 0 8

HI i HAVE THE ABOVE IN A EXCEL spreadsheet, would like to know which formula
would I use to make the total change as the won column counts up from 0 to
whatever. but as it increments i need it to add 8 to the total. Obviously as
the draws increase need 1 to be added.

will.
 
B

Bob Phillips

In the total cell

=C2*8+E2

where C2 is the wins E2 is the draws

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
M

Mike

Should be simple enough but what do you want to total? how many points for a
win and draw, how are bonus points calculated?
 
S

Schubawi

Thanks it was simple so simple I did not think of it. tried to get to
complicated, using formula's,
Well Mike, win = 8 draw = 1 and Bonus point = 1.

so equation is ((win*8+Total)+Draw)

thanks anyway
 
S

Schubawi

Thanks it was simple so simple I did not think of it. tried to get to
complicated, using formula's,
Well Mike, win = 8 draw = 1 and Bonus point = 1.

so equation is ((win*8+Draw)+Bonus)=Total

thanks anyway
 
Top