Hi guys, first time poster, but I am in dire need of some help.

I know very basic controls in excel but am in need of something a little more complex.

I am trying to put in some cricket scores and here is my problem:

When I put in the overs as 8.5(A1), the runs as 41(A2) and the wickets as two(A3), the average works out fine (A2/A3), but the strike rate (A3/A1) and Economy Rate (A2/A1) are wrong. The Strike Rate is coming up as 25.5 when it should be coming up as 26.5 and the Econ Rate is coming up as 4.82 instead of 4.64. I am assuming this is because it is reading 8.5 as 0.5/10 whereas I want it to read 0.5/6.

Can someone please help me with this problem.

Thanks in advance, THB.