Forum Discussion

ross1924's avatar
ross1924
Copper Contributor
Jul 21, 2022

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

 

in my spread sheet though, i have several teams and the players are not always listed with the smaller index first.  Can a formula decipher which index is smaller and use it twice?  or do i have to order them smaller one first?

1 Reply

  • ross1924 

    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