- Run rate is nothing but average runs per over
- So we have to divide the innings total runs by number of completed overs.
- Select cell L2 and enter the formula as =(K2/A2) and press enter
- Run rate after 1st over will get reflected
![](/media/2/5/c/81a177fe3cc8215e7b390b70ad7d56caa54ec983339c3ac801b7c9cba01ed.gif)
- Select cell L3 and enter the formula as =(K3/A3) and press "enter" button.
- Run rate after 2nd over will get reflected.
![](/media/e/f/b/05da6001eca8af4924c10b33179498931c762173f1d721077dce2890c707d.gif)
- Now drag the tiny rectangle of selected cell to reflect formula output for remaining overs.
![](/media/9/f/4/3befb383939158b751a4cb7addc75671c1f1b35dc32cb3459fbdf3c842f7d.gif)
[Contributed by administrator on 15. März 2018 15:02:36]