相关文章推荐
近视的沙发  ·  Power BI 从 Dataverse ...·  1 年前    · 

How can i resolve this problem?

=SI.ERROR(SI.ND(_xlfn.IFS(Tipo=LI!$A$4,LI!Q2,Tipo=LD!$A$4,LD!Q2,Tipo=CE!$A$6,CE!Q3,Tipo=IE!$A$8,IE!Q2,Tipo=IR!$A$5,IR!Q2,Tipo=TR!$A$5,TR!S2,Tipo=OC!$A$5,OC!Q2,Tipo=OR_CUADRADO!$A$4,OR_CUADRADO!Q2,Tipo=OR_RECTANGULAR!$A$4,OR_RECTANGULAR!Q2)," ")," ")

I dont know what to do with "_xlfn.IFS"

Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.

The IFS function was introduced in "Excel 2016". But really the Office 365 subscription service, not standalone Excel 2016.

So if you open the Excel file in a previous version (including standalone Excel 2016), Excel replaces the function name with _xlfn.IFS. That means Excel recognizes that it is an Excel function, but not a function that is supported by the current version of Excel.

As for IFS per se, it is simply shorthand for nesting IF expressions.  So you might write:

=SI.ERROR(SI.ND(IF(Tipo=LI!$A$4, LI!Q2,

IF(Tipo=LD!$A$4, LD!Q2,

IF(Tipo=CE!$A$6, CE!Q3,

IF(Tipo=IE!$A$8, IE!Q2,

IF(Tipo=IR!$A$5, IR!Q2,

IF(Tipo=TR!$A$5, TR!S2,

IF(Tipo=OC!$A$5, OC!Q2,

IF(Tipo=OR_CUADRADO!$A$4, OR_CUADRADO!Q2,

IF(Tipo=OR_RECTANGULAR!$A$4, OR_RECTANGULAR!Q2))))))))), " "), " ")

Replace "IF" with an appropriate function name for your version of Excel (SI?).

PS: Instead of " " (a space), I suggest that you use "" (null string). That allows you to write a formula of the form =IF(A1="",....), which works if A1 is empy or if it contains a formula that fails the SI.ERROR or SI.ND condition.

PPS: The original IFS function as well as the nested IF expressions above return FALSE if Tipo does not match one of the conditions. It might be better to return the null string (""), like when SI.ERROR and SI.ND fail.  To that end, the last line should be

IF(Tipo=OR_RECTANGULAR!$A$4, OR_RECTANGULAR!Q2 , "" ))))))))), ""), "")

Harassment is any behavior intended to disturb or upset a person or group of people. Threats include any threat of suicide, violence, or harm to another. Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect. Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct. Any image, link, or discussion related to child pornography, child nudity, or other child abuse or exploitation.