Hi Sir,
i have one problem with formula Understanding
In I17 this formula is apply to get result of 35.5
=(I15-INT(I16))+IF(MOD(I16,1)=0,0,0.6-MOD(I16,1)-1)
Sir can you explain me how this formula is working to give the result of remaining balls..
<TBODY>
</TBODY>
i have one problem with formula Understanding
In I17 this formula is apply to get result of 35.5
=(I15-INT(I16))+IF(MOD(I16,1)=0,0,0.6-MOD(I16,1)-1)
Sir can you explain me how this formula is working to give the result of remaining balls..
H | I | |
15 | total overs | 50 |
16 | Overs Balled | 14.1 |
17 | Remaining overs | 35.5 |
<TBODY>
</TBODY>
Last edited: