Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

goeagles · 04-21-2009, 09:55 AM

Hey gang, I have an excel question I need help with (I consider myself somewhere between beginner and intermediate so this might be a stupid question).

I'm doing a pool with some buddies and inputting all the results into an Excel sheet to keep track. Various stat categories have different point values. As an example using basketball: points are worth 1, rebounds/assists 2, blocks/steals 3 etc.

(So there'd be stat categories across the top, players name down the side, and that repeated for each game, with each person's entry on seperate excel sheets.)

I wanted to have the columns that require multipliers programmed in so that when I input a players totals, it automatically calculates it. The problem is that I get a 'circular logic' error because I'm basically saying Cell A1 times 2 = Cell A1.

So I realize that the two easiest solutions would be 1) just join online pools that calculate all this for you (not an option for this particular group for various reasons) and 2) to just do the calculations in my head and input the answer without asking Excel to do anything, but I could see other applications for this where the calculations mightn't be so easy (multiplying by fractional numbers for example) and am just curious if there is a way to do this and thought someone here might know. I didn't find Microsoft's office help to be of much use.

04-21-2009, 09:55 AM	#1
goeagles Draft Pick Join Date: Jan 2008	Excel Hey gang, I have an excel question I need help with (I consider myself somewhere between beginner and intermediate so this might be a stupid question). I'm doing a pool with some buddies and inputting all the results into an Excel sheet to keep track. Various stat categories have different point values. As an example using basketball: points are worth 1, rebounds/assists 2, blocks/steals 3 etc. (So there'd be stat categories across the top, players name down the side, and that repeated for each game, with each person's entry on seperate excel sheets.) I wanted to have the columns that require multipliers programmed in so that when I input a players totals, it automatically calculates it. The problem is that I get a 'circular logic' error because I'm basically saying Cell A1 times 2 = Cell A1. So I realize that the two easiest solutions would be 1) just join online pools that calculate all this for you (not an option for this particular group for various reasons) and 2) to just do the calculations in my head and input the answer without asking Excel to do anything, but I could see other applications for this where the calculations mightn't be so easy (multiplying by fractional numbers for example) and am just curious if there is a way to do this and thought someone here might know. I didn't find Microsoft's office help to be of much use.