问题描述:
excel,解读以下函数公式的意思
=IF(ISERROR(SUMPRODUCT(LARGE(($Q11:$AS11="A")*$Q$10:$AS$10,$A11-COLUMN(A1)+1))+$O11-1),"",SUMPRODUCT(LARGE(($Q11:$AS11="A")*$Q$10:$AS$10,$A11-COLUMN(A1)+1))+$O11-1)
=IF($A11=0,1,IF($A11-COLUMN(A1)+1>=0,$O11*1000+$A11-COLUMN(A1)+1,1))
=SUM(MIN(IF($B$11:$F$182=$O11,$H$11:$L$182,10^4)))
=IF(OR(MIN($O$11:$O$182)=O11,AND(COUNTIF($B$11:$F$182,O11)=0,COUNTIF($Q11:$AS11,"A")>0)),"H"&TEXT(""&G11,"0-000"),IF(M11=10^4,"","H"&TEXT(""&M11,"0-000")))
=IF(ISERROR(SUMPRODUCT(LARGE(($Q11:$AS11="A")*$Q$10:$AS$10,$A11-COLUMN(A1)+1))+$O11-1),"",SUMPRODUCT(LARGE(($Q11:$AS11="A")*$Q$10:$AS$10,$A11-COLUMN(A1)+1))+$O11-1)
=IF($A11=0,1,IF($A11-COLUMN(A1)+1>=0,$O11*1000+$A11-COLUMN(A1)+1,1))
=SUM(MIN(IF($B$11:$F$182=$O11,$H$11:$L$182,10^4)))
=IF(OR(MIN($O$11:$O$182)=O11,AND(COUNTIF($B$11:$F$182,O11)=0,COUNTIF($Q11:$AS11,"A")>0)),"H"&TEXT(""&G11,"0-000"),IF(M11=10^4,"","H"&TEXT(""&M11,"0-000")))
问题解答:
我来补答展开全文阅读