Here are some problems that our users have asked and received explanations on
I need help creating a formula. Consist of 3 data points. 2 are weighted 35% and 1 is weighted 30%. The 2 weighted at 35% the value can range from 0% to 100%. The 1 weighted 30% the value range is 0%-11% but the lower the number the better. Example 0%=100% of the 30%weighted, if that makes sense.
Solved by K. J. in 24 mins
I have a problem regarding to Weighted average
Solved by X. J. in 30 mins
I'm trying to determine the weighted average
Solved by Z. C. in 20 mins
I have created a formula with true and false however would like it to be $0 if the cells are blank.
=IF(AND(OR('BT Calculator'!C4="Super/Pension",'BT Calculator'!C4="IDPS"),'BT Calculator'!D4-'BT Calculator'!E4=0),180,540)
Solved by O. E. in 12 mins
I am looking for a way to weight baseball statistics - ex, batting average weighted by times at bat, earned run average weighted by innings pitched.