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..
[TABLE="width: 200"]
<TBODY>[TR]
[TD][/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]total overs[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Overs Balled[/TD]
[TD]14.1[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]Remaining overs[/TD]
[TD]35.5[/TD]
[/TR]
</TBODY>[/TABLE]
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..
[TABLE="width: 200"]
<TBODY>[TR]
[TD][/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]total overs[/TD]
[TD]50[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD]Overs Balled[/TD]
[TD]14.1[/TD]
[/TR]
[TR]
[TD]17[/TD]
[TD]Remaining overs[/TD]
[TD]35.5[/TD]
[/TR]
</TBODY>[/TABLE]
Last edited: