Why not just enter the regular number in the columns, and just do the formula in the total column? Just enter the wins in Columns B thru G Then in H put the formula. H3 would have, with x1 thru x5 replaced with your numbers. =B3*x1+c3*x2+d3*x3+e3*x4+g3*x5 Otherwise, you could enter the number in one column, and have the formula to multiply it in the next. On 21 Mar 2011 at 22:03, Mike Chambers wrote: Subject: Re: Libreoffice calculation [OT] From: Mike Chambers <mike@xxxxxxxxxx> To: Fedora <users@xxxxxxxxxxxxxxxxxxxxxxx> Copies to: "Michael D. Setzer II" <mikes@xxxxxxxxxxxxxxxx> Date sent: Mon, 21 Mar 2011 22:03:30 -0500 > 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. > > 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 > > -- > Mike Chambers > Madisonville, KY > > "The best town on Earth!" > +----------------------------------------------------------+ Michael D. Setzer II - Computer Science Instructor Guam Community College Computer Center mailto:mikes@xxxxxxxxxxxxxxxx mailto:msetzerii@xxxxxxxxx http://www.guam.net/home/mikes Guam - Where America's Day Begins G4L Disk Imaging Project maintainer http://sourceforge.net/projects/g4l/ +----------------------------------------------------------+ http://setiathome.berkeley.edu (Original) Number of Seti Units Returned: 19,471 Processing time: 32 years, 290 days, 12 hours, 58 minutes (Total Hours: 287,489) BOINC@HOME CREDITS SETI 10490968.605283 | EINSTEIN 5602714.540851 ROSETTA 2933735.693119 | ABC 5004638.189001 -- 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
