Ravi Sir's Cards › Excel
Cricket Batting Stats in Excel (card 2 of 2)
Revision card 2 for Cricket Batting Stats in Excel: Runs from boundaries: =(H5*4+I5*6)/E5 gives 53.8%; Rank by runs: =RANK(E5,$E$5:$E$10) gives 1; Team strike rate: =E11/F11*100 gives 104.4.
Read card text
What this card says
2 for Cricket Batting Stats in Excel: Runs from boundaries: =(H5*4+I5*6)/E5 gives 53.8%
Rank by runs: =RANK(E5,$E$5:$E$10) gives 1
Team strike rate: =E11/F11*100 gives 104.4.
Learn this in the lesson: Cricket Batting Stats in Excel: Batting Average, Strike Rate and Player Rank