EXCEL表格中我想用IF函数表达一下,当显示0或者出现错误的时候,则会返...答:IF函数还是会遇到错误值,从而结果返回错误值。 建议公式改为:=IFERROR(IF((I4-'13秋总订单'!U4)=0,"",(I4-'13秋总订单'!U4)),"") 如果不能用IFERROR函数,就改成:=IF(ISERROR(IF((I4-'13秋总订单'!U4)=0,"",(I4-'13秋总订单'!U4))),"",IF((I4-'13秋总订单'!U4)=0,"",(I4-'13...
Excel if函数问题,大神请进!!高分悬赏!!答:=IF(ISERROR(FIND("Consumption",A1)), 公式2,公式1)完整的:=IF(ISERROR(FIND("Consumption",A1)),SUBSTITUTE(SUBSTITUTE(A2,"2018-2023 Global","Global"),"Market Report (Status and Outlook)","Market Growth (Status and Outlook) 2018-2023"),SUBSTITUTE(SUBSTITUTE(A1,"2018-2023 ...