Forum Discussion
excel formula
I have two teammates and they each have an index. player 1 is 6.6 and player 2 is 10.2 I need a formula that will take lower index twice and higher index once. add them together and divide by 3...
Let's say one index is in B2 and the other in D2. The order does not matter.
=(2*MIN(B2,D2)+MAX(B2,D2))/3