R500=0.5;1R1=1.1;12R=12;;1K5=1005;1M=1000000

怎么转换，现在就R500这种不知道怎么转了

EVAL(REPLACE(CONCATENATE(REPLACE(REPLACE(replace(G3,"K","*1000+"),"R","*1+0.1"),"M","*1000000+"),"*1"),"+*1",""))

FineReport 用户AYnW76920187 发布于 2024-7-10 10:07 （编辑于 2024-7-10 11:04）

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：3 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共2回答

最佳回答

CD20160914Lv8专家互助
发布于2024-7-10 11:53

if(RIGHT(A9,1)="K",EVAL(REPLACE(A9,"K","*1000")),EVAL(REPLACE(A9,"K","*1000+")))+

if(RIGHT(A9,1)="M",EVAL(REPLACE(A9,"M","*1000000")),EVAL(REPLACE(A9,"M","*1000000+")))+

if(RIGHT(A9,1)="R",EVAL(REPLACE(A9,"R",""))*1,if(LEFT(A9,1)="R",REPLACE(A9,"R","")/1000,

EVAL(REPLACE(A9,"R","*1+0.1"))))

华莉星宸Lv7资深互助
发布于2024-7-10 10:16

要写判断，你要判断R的位置，乘对应的系数

试试

if(left(G3,1)="R",EVAL(REPLACE(CONCATENATE(REPLACE(REPLACE(replace(G3,"K","*1000+"),"R","*0.001"),"M","*1000000+"),"*1"),"+*1","")),if(right(G3,1)="R",EVAL(REPLACE(CONCATENATE(REPLACE(REPLACE(replace(G3,"K","*1000+"),"R","*0.1"),"M","*1000000+"),"*1"),"+*1","")),EVAL(REPLACE(CONCATENATE(REPLACE(REPLACE(replace(G3,"K","*1000+"),"R","*1+0.1"),"M","*1000000+"),"*1"),"+*1",""))))

举报收起评论(2)

用户AYnW76920187(提问者) R100的没有代换出来

2024-07-10 11:05

华莉星宸回复用户AYnW76920187(提问者) if(left(G3,1)="R",EVAL(REPLACE(CONCATENATE(REPLACE(REPLACE(replace(G3,"K","*1000+"),"R","0.001*"),"M","*1000000+"),"*1"),"+*1","")),if(right(G3,1)="R",EVAL(REPLACE(CONCATENATE(REPLACE(REPLACE(replace(A2,"K","*1000+"),"R","*1"),"M","*1000000+"),"*1"),"+*1","")),EVAL(REPLACE(CONCATENATE(REPLACE(REPLACE(replace(G3,"K","*1000+"),"R","*0.1+"),"M","*1000000+"),"*1"),"+*1",""))))

2024-07-10 11:48