开贴 字符争霸-第四期 计算整数末尾0的个数

xdragon

1. =SUM(N(RIGHT(A9,ROW(INDIRECT("1:"&LEN(A9))))%=0))

复制代码

三键

1. =LEN(SUBSTITUTE(A2,MID(-("."&A2),4,99),""))

复制代码

1. =20-LEN((1&A2)*1E-18)

复制代码

这个不知道算不算，因为输入后，长度有变化。。。不符合19次方的。。无视这个吧。。。

1. =SUM(N(RIGHT(1&A2,ROW($1:$99))%=0))

复制代码

hsl215

钻 个空子{:1012:}
=LEN(A2)-LEN(SUBSTITUTE(A2,"0",""))-IF(LEFT(A2,LEN(SUBSTITUTE(A2,"0","")))<>SUBSTITUTE(A2,"0",""),1,0)
=LEN(A2)-LEN(SUBSTITUTE(A2,"0",))-IF(LEFT(A2,LEN(SUBSTITUTE(A2,"0",)))<>SUBSTITUTE(A2,"0",),1)

yunqingzi

{=IF(A2=0,1,LEN(A2)-LEN(SUM(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)*10^(ROW(INDIRECT("1:"&LEN(A2)))-1))))}

q070314230

=IFERROR(LOOKUP(1,0/(--RIGHT(A2,ROW(INDIRECT("$1:$"&LEN(A2))))=0),ROW(INDIRECT("$1:$"&LEN(A2)))),0)

q070314230

=IF(A2>0,SUMPRODUCT(N(A2/(10^ROW($1:$16))=INT(A2/(10^ROW($1:$16))))),1)

江河行地

=SUM((-RIGHT(1&A2,ROW($1:17))=0)*1)

hongqiqqq

1. =MAX((--RIGHT(A2,ROW(INDIRECT("$1:$"&LEN(A2))))=0)*ROW(INDIRECT("$1:$"&LEN(A2))))

复制代码

三键

lasharks

1. =SUM(N(RIGHT(TEXT(A2,"10#"),ROW($1:$20))*1=0))

复制代码

三键下拉

zjcat35

1. =MAX(ROW($1:19)-RIGHT(9&A2,ROW($1:19)),0)

复制代码

metoo77

1. {=MAX(IF(MOD(LOG(1&RIGHT(A2,ROW($1:$20))),INT(LOG(1&RIGHT(A2,ROW($1:$20)))))=0,LOG(1&RIGHT(A2,ROW($1:$20)))))}

复制代码

1. 
   
2. {=LEN(A2)-IFERROR(MATCH(1,MID(A2,ROW($1:$20),1)/MID(A2,ROW($1:$20),1),1),0)}

复制代码

1. {=IF(A2=0,1,FREQUENCY(--RIGHT(A2,ROW($1:$20)),0))}

复制代码