Kim said:
I am a real novice here. I am keeping track of placements
in speedskating. 1st place = 30 points, 2nd place = 20
points and so on. There are several races that we need to
keep track of. How can I make it so that I can type
in "1" for 1st place and have it autimatically tally
up "30" for the point value?
Simply create a formula in an adjacent cell so that the points are generated
from the place. There's a couple of ways to do this, one is from a table
that looks up the place value and takes the corresponding points value. Read
up on the HLOOKUP and VLOOKUP functions. Another method is using nested IF
functions e.g.
If cell A1 had the place, then B1 would have =if(A1=1, 30, if (A1=2, 20,
0)).
If there's an easy formula relationship between the points and place value,
then you could use a forumla for that.
At the bottom of the points column, simply use the SUM() function.
--
Mike Williams - Office MVP
http://www.mvps.org/faq/
Please respond in the same thread on this newsgroup - not by email!
Include details of your application and Windows versions, plus any
service pack updates. Answers may also be found by reading recent
posts, checking the FAQs or searching the relevant Google archive at.
http://groups.google.com/groups?group=microsoft.public
