=IF(B3
IF(B3="","",IF(VALUE(DATEDIF(B3,C3,"D"))>=6575,"有资格","无资格"))
请教这个公式的使用方法=IF(C3="","",IF(B3="",TEXT(NOW(),"yyyy-m-d"),B3))
关于IF的多条件用法请问,if(a1>=b1,b1,if(a1>=b2,b2,if(a1>=b3,b3))),这个函数用
函数公式=MID(B3,7,4)&MID(B3,1,2)&MID(B3,4,2)&"A"和=IF(A3="A",D2,I
公式“=IF(ISERROR(VLOOKUP(B8,数据表!B3:AE629,3,FALSE)),"",VLOOKUP(
=IF(ISNUMBER(FIND("ABC",B3)),12345,67890) 这个函数里面的ISNUMBER是什么
excel中:如何实现=if(a2=d2,b2=e2,if(a3=d3,b3=d3,if(a4=d4,b4=e4,if(
Excel公式错误.=IF(A2="郭鹏",B3,IF(A2="彭辉",1.5%,IF(A2="卜珊珊",2%,IF(A
excel公式简化下=IF(AND(B3="",C3="",D3="",E3="",F3="",G3=""),"",SU
=IF(OR(A3="",B3=""),"",A3-41)/A3这个公式是什么意思,计算的步骤是怎么样的?
=LEFT(B3,FIND(" ",B3)-1) excel的公式