Slopes and indices

[steverpi75]

Hello,

I'm trying to build an "index" system. Basically, the indicator would get full points, 0.02 pts, for being greater than or equal to 95; max of 100. As you fall lower than 95 to a minimum of 85, 0.00 pts, you lose points linearly. I tried making a slope equation but I can't get past the 95-100 part.

This is what I made so far, but it isn't correct.:
y=(0.02-0.00/95-85)x + 0

where X is 0 - 100

Thanks for the help.

 

[pgc01]

Hi steverpi75

You say "where X is 0 - 100" but you don't talk about the range 0-85.

What I understood:

[95-100], y=0.02

[85-95[, y=(x-85)/500 (up linearly from x=85 to 95, y=0 to 0.02)

[0-85[, you forgot to specify

The formula is, assuming x in A1

=IF(A1>=95,0.02,IF(A1>=85,(A1-85)/500,"Not specified"))

Hope this helps
PGC

 

[steverpi75]

That is what I needed. Thanks PGC.