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 results
this needs to be in approx 30 cells on x axis
So every time i type in a score 0 - 10 it gives a result as a percentages.
Am I over thinking this, i just cant work it out!
Thanks for any help
Dino
11 Replies
- Hi this works for individual cells, but i need it to correlate and sum C5 to L5, then C6 to L6, and so on
Any more help is appreciated
Thanks
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.
ThanksPerhaps
=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.
