作业帮H2=IF(SUMPRODUCT(--(RIGHT(A2:G2)=RIGHT(A1))),"对","错"),
H2=IF(SUMPRODUCT(--(RIGHT(A2:G2)=RIGHT(A1))),"对","错"),
excel 表格公式修改：=IF(SUMPRODUCT(ISNUMBER(FIND(G2:H2:I2,"1234567"
excel if函数问题,A1=11,A2=RIGHT(A1,1),A3-IF(A2=1,"1","0") 为什麽显示0
如果只有两位数,可用公式 =LEFT(A1)+RIGHT(A1) 位数不定,公式为 =SUMPRODUCT(--MID(
IF(OR(G2="",H2=""),"",ROUND(DAYS360(G2,H2)/360,0)) 在excel表中这
求A2=C2+D2=F2+G2+H2公式
请问这个公式错在哪H2=IF(AND(A2"",C2="",D2="",E2="",F2>0,G2=吨),F2,""）
=sumproduct(if(istext(A1:A100),50,A1:A100)*B1:B100) 错哪了
=RIGHT(A2,LEN(A2)-FIND("-",A2))这个函数是什么意思?
=SUMPRODUCT((A2:A9="广")*(B2:B9="3#")*(C2:C9="12")*(G2:G9="52
excel函数中 =AND(RIGHT(A1,1)"市",RIGHT(A1,1)"县")
=SUMPRODUCT(--LEFT(A1:B1,FIND("+",A1:B1)-1))&"+"&SUMPRODUCT(