请教老师用公式，把尾数与尾数和值分别显示，谢谢！

cartel

请教老师用公式，把尾数与尾数和值分别显示，谢谢！.zip (15.91 KB, 下载次数: 28)

2024-6-19 10:34 上传

点击文件名下载附件

bsgn2017

1. F:
   
2. =CONCAT(REGEXEXTRACT(E1,"\d,|\d$",1))
   
3. 
   
4. G:
   
5. =SUM(TEXTSPLIT(F9,",")^1)

复制代码

leepoison

=DROP(REDUCE("",E1:E3,LAMBDA(x,y,VSTACK(x,HSTACK(TEXTJOIN(",",TRUE,RIGHT(REGEXP(y,"\d+"))),SUM(--RIGHT(REGEXP(y,"\d+"))))))),1)

秃头发师

=TEXTJOIN(",",1,RIGHT(TEXTSPLIT(E1,","),1))
=SUM(--RIGHT(TEXTSPLIT(E1,","),1))

无关岁月

1. =LET(_a,MOD(TEXTSPLIT(E1,","),10),HSTACK(TEXTJOIN(",",,_a),SUM(--_a)))

复制代码

inrever

1. =HSTACK(TEXTJOIN(",",,RIGHT(REGEXP(E1,"\d+"),1)),SUM(--RIGHT(REGEXP(E1,"\d+"),1)))

复制代码

hugeinfo

=TEXTJOIN(",",,RIGHT(TEXTSPLIT(E1,,","),1))
=SUM(--RIGHT(TEXTSPLIT(E1,,","),1))