[已解决]括号问题

keevenhk

在Sheet2写了1个函数提取Sheet1中单元格的数值, 如下:
=SUBSTITUTE(IF($A1="","",VLOOKUP($A1,sheet1!$A:$H,8,0)),"x","(x)",8)
原Sheet1的数值是94529120, 冀在sheet2提取后会显示为9452912(0)的, 可是现时仍显示94529120, 请问公式出现什么问题, 请帮忙解决一下, 谢谢.

最佳答案

月排行榜 / 总排行榜

lotte

2012-6-6 10:03

要是试试这个？

1. =REPLACE(REPLACE(IF($A1="","",VLOOKUP($A1,Sheet1!$A:$H,8,0)),8,,"("),10,,")")

复制代码

跳转到最佳答案楼层

lotte

=SUBSTITUTE(IF($A1="","",VLOOKUP($A1,sheet1!$A:$H,8,0)),"x","(x)")

不知道你的意思，乱猜
=SUBSTITUTE(IF($A1="","",VLOOKUP($A1,Sheet1!$A:$H,8,0)),0,"(0)")

lotte

要是试试这个？

1. =REPLACE(REPLACE(IF($A1="","",VLOOKUP($A1,Sheet1!$A:$H,8,0)),8,,"("),10,,")")

复制代码

lotte

要是试试这个？

1. =REPLACE(REPLACE(IF($A1="","",VLOOKUP($A1,Sheet1!$A:$H,8,0)),8,,"("),10,,")")

复制代码

gaoshuichang1

Book1.zip (2.13 KB, 下载次数: 0)

2012-6-6 11:13 上传

点击文件名下载附件

这个公式太笨了,你试试看
=SUBSTITUTE(IF($A1="","",VLOOKUP($A1,Sheet1!$A:$H,8,0)),RIGHT(VLOOKUP($A1,Sheet1!$A:$H,8,0),1),"("&RIGHT(VLOOKUP($A1,Sheet1!$A:$H,8,0),1)&")",LEN(VLOOKUP($A1,Sheet1!$A:$H,8,0))-LEN(SUBSTITUTE(VLOOKUP($A1,Sheet1!$A:$H,8,0),--RIGHT(VLOOKUP($A1,Sheet1!$A:$H,8,0),1),"")))