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.

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)

"Schubawi" wrote in message
...
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.

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

"Schubawi" wrote:

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.

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

"Mike" wrote:

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

"Schubawi" wrote:

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.

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

"Mike" wrote:

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

"Schubawi" wrote:

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.