Re: Libreoffice calculation [OT]

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!"

--
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

Quantcast