Add value as changes

[Guest]

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.

 

[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)

 

[Guest]

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

 

[Guest]

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

 

[Guest]

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