A1等于1时,B2等于0 A1等于0时,B2等于-10 A1等于2时,b2等于20答:Excel表格中如果A1不等于0,B1不等于0,C1不等于0,则令D1等于10秒钟,A...答:D1填公式: =IF(AND(A10,B10,C10),10,0) D2填公式: =IF(AND(A20,B20,C20),10+D1,IF(AND(A2=0,B2=0,C2=0),D1,"")) 然后D2格下拉
Office Excel 2007 请高手帮忙答:To i aStr = Mid(Str2, k, 1)Str1 = Replace(Str1, aStr, "", 1, 1, vbTextCompare)Next For k = 1 To j aStr = Mid(Str3, k, 1)Str1 = Replace(Str1, aStr, "", 1, 1, vbTextCompare)Next MinusString = Str1 End Function 3、在D2使用公式=MinusString(A1,A2,A3)...