Forum Discussion
Excel formulas Help
Hi, This is probably simple, but....... i need a formula to give me a score of a field of results. x axis score of 9 or 10 = 100% 8 to 5 =50% 4 to 0 = 0% Total is percentage of result...
Hi,
No, this is not right either.
It just returns a value of 1.
I need the end value to be in percentage form.
So, if the scores are 10, 10, 10, ect, the final column would show 100%
But if the scores are 8, 8, 8 this would show 50%
But I also need the formula to work out the percentages, if the scores were 10, 8, 8
I hope this is clearer.
Thanks
Darren
Please provide a series of examples that comprehensively show what you want.
- So, in the attached pic:
C3,D3,E3 would = 100%
F3 would = 50%
I need a total in percentage in G3
In row 14
C14 = 50% D14 = 0% E14 = 0% but if I changed F14 to a score of 9, that would = 100%
So the total in G14 is a running percentage.
I have attached a condensed pic, the actual chart will be bigger
I hope this makes more sense
Thanks
DarrenThat's not clear at all, since you don't tell us what the expected outcome should be.
Perhaps in G3:
=SUMPRODUCT(LOOKUP(C3:F3,{0,5,9},{0,0.5,1}))Format G3 as a percentage and fill down.
- Hi,
The expected outcome is a percentage of the scores in in C3- F3
So: C3 = score 9 which is 100%
D3 = score 10 which is 100%
E3 = score 9 which is 100%
F3 = score 8 which is 50%
So G3 (TOTAL)needs to be an overall percentage of C3,D3,E3 and F3
a score of 9, 10 = 100%
a score of 8,7,6,5,4 = 50%
a score of 3,2,1,0 = 0%
I hope this is clearer
Thanks
Dino
