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
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