Cricket Scorecard

[wayne0881]

Hi All,

I am working on a Cricket scorecard in excel and have hit a problem -

A one day game has 50 overs with 6 balls per over which is 300 balls

For example cell C3 has 50 (representing overs), cell C4 has overs played for this example we'll say 48.2
meaning in Cell C5 i would like 1.4 overs left but if I do C3-C4 it gives me 1.8 (which is mathmatically correct)

What do I have to do to the sum to make it calculate properly to 1.4 ie, keep in a range of 0.1-0.6

Thanks

 

[Fluff]

How about
=DOLLARFR(DOLLARDE(C3,6)-DOLLARDE(C4,6),6)

 

[wayne0881]

Works like a dream.

Thankyou

 

[Fluff]

You're welcome & thanks for the feedback