Forum Discussion
cmckernan93
Aug 08, 2022Copper Contributor
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...
- Aug 08, 2022
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))
Jagodragon
Aug 08, 2022Iron Contributor
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))