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, thanks for the reply, but it has not worked.
I just get a value of 1 in the cell
I need to go from C5 to L5
If i try to extend the firmula by:
=IF(C5,L5<4,0%,IFC5,L5<8,50%,100%))
That does not work either
Any help would be gratefully appreciated.
Thanks
I just get a value of 1 in the cell
I need to go from C5 to L5
If i try to extend the firmula by:
=IF(C5,L5<4,0%,IFC5,L5<8,50%,100%))
That does not work either
Any help would be gratefully appreciated.
Thanks
Perhaps
=IF(SUM(C5:L5)<4,0%,IF(SUM(C5:L5)<8,50%,100%))This can be filled down.
If that does not do what you want, please explain more clearly what you want to accomplish.
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
DarrenPlease 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
Darren
