- 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
- Select cell L3 and enter the formula as =(K3/A3) and press "enter" button.
- Run rate after 2nd over will get reflected.
- Now drag the tiny rectangle of selected cell to reflect formula output for remaining overs.
[Contributed by administrator on 15. März 2018 15:02:36]