Forum Discussion

cmckernan93's avatar
cmckernan93
Copper Contributor
Aug 08, 2022

formula help - calculating score needed to bring score past certain marks

  Hello   in the table below i need a formula or help in how to calculate how many 5 star reviews it will take to bring the current rating up to above 3.5 and 4 stars and also 5 stars (this column...
  • Jagodragon's avatar
    Aug 08, 2022

    cmckernan93 

     

    Put this formula in J2 and drag it down to fill the column

    =IF(3.5<$D2,"",(($C2*$D2)-(3.5*$C2))/(3.5-5))

     

    Put this formula in K2 and drag in down to fill the column

    =IF(4<$D2,"",(($C2*$D2)-(4*$C2))/(4-5))

Resources