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...
Let's say your results are in B2:B30.
Enter the following formula in C2:
=IF(B2<=4,0%,IF(B2<=8,50%,100%))Fill down to C30.
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.