Hi everyone,
I'm working on a spreadsheet to calculate average scores from a given range,where they're 0-100. What I have is working fine, however for the purpose ofranking the averages I need to treat scores that are < 75 as 50 whencalculating the averages.
Eg. Scores are 100, 89, 85, 76, 74, 66 currently
is 81.667
I need the average to calculate based on 100, 89, 85, 76,50, 50 returning 75
I want to retain the original scores for graphing, justneed the 50 for calculations.
Does anyone have any suggestions? TIA
I'm working on a spreadsheet to calculate average scores from a given range,where they're 0-100. What I have is working fine, however for the purpose ofranking the averages I need to treat scores that are < 75 as 50 whencalculating the averages.
Eg. Scores are 100, 89, 85, 76, 74, 66 currently
Code:
=AVERAGE(that range)
I need the average to calculate based on 100, 89, 85, 76,50, 50 returning 75
I want to retain the original scores for graphing, justneed the 50 for calculations.
Does anyone have any suggestions? TIA