Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
How to display total runs calculated in every 5 over of a cricket match ?
I used class function but problem is that it segregated 20 over into 5 parts .
Actually it should in 4 parts ; 1-5,6-10,11-15,16-20 .
Though i I used class function .
Thanks & Regards
Shekar
you can try with the last parameter of the class function, offset
something like
=dual(
subfield(class(over,5), '<', 1) +1 & ' - ' & subfield(class(over,5), '<', 3) ,
class(over,5, 'over', 1)
)
you can try with the last parameter of the class function, offset
something like
=dual(
subfield(class(over,5), '<', 1) +1 & ' - ' & subfield(class(over,5), '<', 3) ,
class(over,5, 'over', 1)
)
Hi Massimo ,
Thanks for reply . This worked .
Is there any other way around , apart from using class function .
if
=if(over <= 5, '1-5',
if(over <= 10, '6-10',
if(over <= 15, '11-15',
if(over <= 20, '16-20'
))))