|
最佳回答 |
0
|
weibwLv7高级互助发布于2022-11-10 08:45
|
if(find("kv",字段)>0,replace(字段,"kv","")*1000,replace(字段,"v",""))
|
|
|
|
最佳回答 |
0
|
Z4u3z1Lv6专家互助发布于2022-11-10 08:42(编辑于 2022-11-10 08:48)
|
REPLACE(REPLACE(B1,'V',''),'K','')*100--假设是在B1 ---------------- 乘1000 少打个0. 囧
|
|
|
|
最佳回答 |
0
|
snrtuemcLv8专家互助发布于2022-11-10 08:44(编辑于 2022-11-10 08:45)
|
if(find('kv',A1)>0,replace(A1,"kv","")*1000,replace(A1,"v",""))
|
|
|
|
最佳回答 |
0
|
CD20160914Lv8专家互助发布于2022-11-10 08:50(编辑于 2022-11-10 08:50)
|
if(right(a2)="v",left(a2,len(a2)-1),if(right(a2,2)="kv",replace(a2,"kv","")*1000,a2))
|
|
|