Scores in a Range

[ChetKG]

Hi

I am looking for some help, been fiddling with excel most of last night but not any closer to solving this little problem.

Lets say I have some test results, based on the % achieved you get some points (which will be used later in combination with other test results).

Any score under 60% you get 0 points, any score above 95% you get 100 points.... so anything between 60 and 95 would earn you some points based on a scale... Could anyone help me define a formula i can use for this?

Appreciate any help

 

[ranman256]

Create a custom formula.
Usage:
=GetScore(A4)

public function GetScore(byval pvAmt)
   Select case pvAmt
      Case .95
         GetScore=100
      Case .85
          GetScore=90
      Case <.65
           GetScore=0
    End select.
end function

 

[Peter_SSs]

See if this does what you want. If not, could you give some specific examples, the expected results an an explanation of the expected results?

Excel Workbook
	A	B
1	Score	Points
2	50%	0
3	98%	100
4	63%	8.57143
5	95%	100
6	88%	80
7	72%	34.2857
8	3%	0
9	77.50%	50
Score - Points