I have 3 possible evaluation values in my spreadsheet (I have to use the values with digits and words):
- 1.0 - Doesn't meet expectations
- 2.0 - Meets expectations
- 3.0 - Exceeds expectations
The goal - is to calculate the average evaluation point, like 2.5 I tried to use IF condition, but it works only for 2 values, and I have 3.
Could you please advise how can I calculate in separate column on at the bottom of the column with my values the average digit?