[已解决]急急，公式太长，输不完怎么办？

汶川加油

本个有一公式如下：
=MAX(IF(COUNT(VLOOKUP(A439,'3折'!$A$4:$U$83,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$4:$U$83,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$86:$U$93,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$86:$U$93,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$96:$U$111,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$96:$U$111,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$114:$U$118,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$114:$U$118,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$121:$U$123,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$121:$U$123,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$125:$U$129,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$125:$U$129,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$132:$U$138,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$132:$U$138,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$141:$U$148,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$141:$U$148,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$151:$U$155,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$151:$U$155,21,FALSE),0),IF(COUNT(VLOOKUP(A439,'3折'!$A$158:$U$165,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$158:$U$165,21,FALSE),0))，还需输两行IF(COUNT(VLOOKUP(A439,'3折'!$A$167:$U$170,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$167:$U$170,21,FALSE),0)，IF(COUNT(VLOOKUP(A439,'3折'!$A$172$U$175,21,FALSE))>0,VLOOKUP(A439,'3折'!$A$172:$U$175,21,FALSE),0)，可是EXCLE显示公式太长，望高人指点！万分感谢！本人太菜，最好能帮忙改好公式！

3OZtK19W.rar (89.5 KB, 下载次数: 7)

2010-6-8 12:08 上传

点击文件名下载附件
急急，公式太长，输不完怎么办？

最佳答案

月排行榜 / 总排行榜

帅

2010-6-8 12:17

=MAX(IF(COUNT(VLOOKUP(A4,'3折'!$A$4:$U$206,21,))>0,VLOOKUP(A4,'3折'!$A$4:$U$206,21,),0))

跳转到最佳答案楼层

帅

=MAX(IF(COUNT(VLOOKUP(A4,'3折'!$A$4:$U$206,21,))>0,VLOOKUP(A4,'3折'!$A$4:$U$206,21,),0))

htcaiwuke

[em17]

木文

字符有这么长了.

nichangdong

学习一下

coolliangfen

是不短哦，晃啊晃