is it possible and if it is how :S

animuslo

New member
Joined
Jun 5, 2014
Messages
2
Reaction score
0
Points
0
Hi everyone,

I am a sports coach, which is trying to implement the excel spreadsheet as part of the athlete evaluation process. Since there are few tests which are depended on different anthropocentric data I would like to know if it is possible/how it is possible to create in one cell formula which would be able to check what value is in one cell and than choose appropriate formula for execution.

Example:
Athlete A = 1.97 m tall (A1)
Athlete B = 1.85 m tall (A1)

Optimal results are created on given table where athletes from 1.90 to 2.0 height have different requirements than athletes from 1.80 to 1.90 m. I would like to describe in third cell (evaluation of data) that if there are athletes on the first given range use the formula A1*2.5 or if they are 1.85 they would have A1*3.0.

Thanks for your help

Animuslo
 

animuslo

New member
Joined
Jun 5, 2014
Messages
2
Reaction score
0
Points
0
Do you mean?

=A1*IF(A1>=1.9,2.5,4)

Athlete No
HeightOptimal score
11.97??????
21.80?????
31.82?????

There are two different type of regressions to be used given the height. If athlete is 1.97 tall he would need to have optimal score calculated with =33.34 + 3.4 * Height-10- And for athletes height range 1.80 to 1.89 would be formula =20.34+3.4 * Height. Is is possible to put in the formula under optimal score column which would be choosing either first regression or second regression based on the value in the height column?
 

NBVC

Super Moderator
Staff member
Joined
May 20, 2011
Messages
1,518
Reaction score
0
Points
0
Location
Mississauga, Canada
Excel Version(s)
Excel 2016
It would be a similar formula, I think.

=3.4*A1+IF(A1>=1.97,33.34,20.34)

Note: Not sure what the -10- means and if it is supposed to be part of any logic in the formula....
 
Top