ExcelDummy
New Member
- Joined
- Sep 13, 2002
- Messages
- 11
I am trying to create a points sheet. What I have not been able to do is figure out a formula that will work.
In one cell I need to enter a number that would be a 1, 2, 3, 4 or 5. If I enter the number 1, it will delegate 30 points in a given cell, if I enter the number 2, it will delegate 40 points and so on.
In one cell I need to enter a number that would be a 1, 2, 3, 4 or 5. If I enter the number 1, it will delegate 30 points in a given cell, if I enter the number 2, it will delegate 40 points and so on.