Forum Discussion

Dinodog's avatar
Dinodog
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
HansVogelaar's avatar
HansVogelaar
MVP
Nov 10, 2020

Dinodog 

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.

  • Dinodog's avatar
    Dinodog
    Copper Contributor
    Nov 15, 2020
    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
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Nov 15, 2020

      Dinodog 

      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.

      • Dinodog's avatar
        Dinodog
        Copper Contributor
        Nov 19, 2020

        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

Resources