Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Apr 2006
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need Formula for Points (Excel 2002 )

    I need to create a formula for my point system.

    0 findings = 0 points
    1 - 10 findings = 1 point
    11 - 20 findings = 2 points
    21 - 30 findings = 3 points and so on...

    Column A would be the findings and Column B would be the points; so for example if A2 is any number between 1 and 10, B2 would calculate 1. If A2 is anything between 11 and 20, B2 would calculate 2, and so on.

    Your help is greatly appreciated.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need Formula for Points (Excel 2002 )

    You could use

    =CEILING(A2/10,1)

    or

    =ROUNDUP(A2/10,0)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •