Hi all,
first post here so excuse me if it isn't very clear.
What I want to do is create a score value from 1-10 (1 being 'poor' and 10 being 'good') based on the values of other cells. I have 4 cell values which I want to use which all have a poor score and a good score, see below for the scores. first number is a 'poor' score and second number is 'good' score.
Compliance - 85-100
Micro - 10-0
Output - 100-200
Fails - 5-0
I want it use specific values within those ranges that will move the overall score between 1-10 if possible, so for example if all were the 'poor' then 0 overall score would be returned and if all were 'good' then 10 would be returned. One cell is a percentage but can be used as a decimal if needed.
first post here so excuse me if it isn't very clear.
What I want to do is create a score value from 1-10 (1 being 'poor' and 10 being 'good') based on the values of other cells. I have 4 cell values which I want to use which all have a poor score and a good score, see below for the scores. first number is a 'poor' score and second number is 'good' score.
Compliance - 85-100
Micro - 10-0
Output - 100-200
Fails - 5-0
I want it use specific values within those ranges that will move the overall score between 1-10 if possible, so for example if all were the 'poor' then 0 overall score would be returned and if all were 'good' then 10 would be returned. One cell is a percentage but can be used as a decimal if needed.