Mike, On Mon, Mar 21, 2011 at 8:03 PM, Mike Chambers <mike@xxxxxxxxxx> wrote: > On Tue, 2011-03-22 at 12:47 +1000, Michael D. Setzer II wrote: >> Not real clear on what you are trying to do. > > Basically what I am messing with, is the March Madness bracket office > pool we have at work. I take the number of wins for a round (example, 5 > wins) and want to be able to just input that number into the cell, and > have it automatically multiply by a set number that scores for that > round (example, 10). > > Maybe this will help > > Round 2 scores 4 points per win. Someone gets 10 wins for that round. > That would be 40 total points for that round. So I want to be able to > just input the 10 and have it automatically multiply by 4 for me, > instead of doing it in my head/on calculator. I also will be printing > this sheet out (maybe converting to html first) to let everyone keep > updated with the scores. So except for the info for the brackets, > nothing else needs to be on there. So way out to the right in column "z" put the number you want multiplied, then in the column you want the result to show up in you put the calculaton/algorithm. So say in D3 you would put: =sum(z3 * 4) in D4 you would put: =sum(z4 * 4) D5: =sum(z5 *4) Put the next round in column AA and the result in column E does that make sense? Does that give you what you want? When you go to print off the spread sheet, just limit it to the results columns. > > Gonna post a URL to let you see what it currently looks like (html form) > to get an idea of what I want seen. Any calculations that need done are > to be hidden and not seen. > > http://www.miketc.net/bracket.html What multiplier did you use for round 1, 1? > > -- > Mike Chambers Darlene Wallach -- equal justice under law -- users mailing list users@xxxxxxxxxxxxxxxxxxxxxxx To unsubscribe or change subscription options: https://admin.fedoraproject.org/mailman/listinfo/users Guidelines: http://fedoraproject.org/wiki/Mailing_list_guidelines
