Dividing by base 6

[Barking_Mad]

Hi,

I have a spreadsheet (cricket if this helps!) where numbers with a decimal point have to work in base 6 (as opposed to base 10). For instance counting from 22 to 23 would go,

22
22.1
22.2
22.3
22.4
22.5
23

The problem I have is that I need to divide this number into another number (runs conceded per over) and retain a base 6 answer. So for instance:

83 divided by 22.5 = 3.63 (in base 6)

and not

83 divided by 22.5 = 2.68 (in base 10)

Can anyone help me with this? I have just noticed after some time that many of my figures are wrong because i didn't account for it. They are only slightly out, but it's important!

Thanks

[DonkeyOte]

Not clear which version you're using... if you're running pre XL2007 and want to avoid Analysis ToolPak then:

=A1/(INT(B1)+MOD(B1,1)/0.6)

else if you have ATP activated

=A1/DOLLARDE(B1,6)

where A1 holds runs conceded and B1 overs bowled

[Barking_Mad]

As if by magic!

Cheers very much for you help (again), appreciated as always