Forum Discussion

Copper Contributor

Nov 10, 2020

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...

Formulas and Functions

SergeiBaklan

Diamond Contributor

Nov 10, 2020

Dinodog

As variant

=INT((A1-0.5)/4)/2

Dinodog

Copper Contributor

Nov 15, 2020

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