Nov 10 2020 08:09 AM
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
Nov 10 2020 08:49 AM
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.
Nov 15 2020 02:49 PM
Nov 15 2020 02:57 PM
Nov 15 2020 03:04 PM
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.
Nov 19 2020 03:59 AM - edited Nov 19 2020 04:00 AM
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
Nov 19 2020 04:03 AM
Please provide a series of examples that comprehensively show what you want.
Nov 19 2020 04:20 AM
Nov 19 2020 06:33 AM
That'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.
Nov 19 2020 09:14 AM
Nov 19 2020 10:36 AM
@Dinodog I think what you want is to take and average of the % values
=AVERAGE(INT(C3:F3/4.1)/2)
and fill down.
unless you want the original numbers (9, 10, 9 ,8) to be averaged first and then have the % transformation applied, but I don't think so.