如何让excel公式无数据输入时显示空白?答:使用下列公式之一 =IF(OR(H6="",I6=""),"",IFERROR(DATEDIF(H6,I6,"D"),""))=IF(COUNT(H6:I6)<2,"",IFERROR(DATEDIF(H6,I6,"D"),""))=IF(COUNTBLANK(H6:I6),"",IFERROR(DATEDIF(H6,I6,"D"),""))下拉填充
Excel函数mid为空时,怎样返回也为空?求高手!答:=IFERROR(INDEX({"A","B","C","D"},MATCH(1,--ISNUMBER(MATCH({"A","B","C","D"},C4:D4,0)),0)),"")=IF(COUNTIF(C4:D4,"A")>0,"A",IF(COUNTIF(C4:D4,"B")>0,"B",IF(COUNTIF(C4:D4,"C")>0,"C",IF(COUNTIF(C4:D4,"D")>0,"D","")))这个通俗...