I am having a problem calculating innings pictched. I am using the following formula:
=DOLLARFR(SUMPRODUCT(INT(D69:D73)+DOLLARDE(MOD(D69:D73,1),3)),3)
When I calculate the following with the above formula:
D69 = 7
D70 = 0
D71 = 0.1
D72 = 0.1
D73 = 0.1
I get a total of 7.3, but what I should be getting is 8. There are 3 outs in an inning so in my thoughts I should never see 7.3 it should drive it to the next number as in 8.![]()
Bookmarks