Libreoffice calculation [OT]

[Mike Chambers]

On Mon, 2011-03-21 at 22:03 -0500, Mike Chambers 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.
> 
> 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.

Thanks everyone for your help.  Guess I've realized that pretty much no
way to do what I want without involving other cells to use.  Nothing a
format of those cells to hide them won't do I guess.

Pretty much what everyone said to do by using other rows is what will
happen.  Thanks again everyone.

-- 
Mike Chambers
Madisonville, KY

"The best town on Earth!"