檔案中有超過2萬幾行資料及公式, 發覺想將這2萬幾行公式刪除時, 都要花上6-7分鐘時間,
就算將計算方法轉為手動都沒有分別,
請問會有其它方法加快速度嗎?
另外這兩條計算相同結果的公式, 請問那一條計算應該會更有效率,
=IF(D7=1,IF(LEFT(G7,4)<>"HF01",IF(G7<>"ZZZZ-ZZZZ-01",IF(NOT(H7),IF(I7<>100,IF(J7=0,IF(K7<>"INVOICED",IF(K7<>"VOID",IF(L7<>"VOID",IF(L7<>"INVOICED","x",""),""),""),""),""),""),""),""),""),"")
=IF(AND(LEFT(E3,4)<>"HF01",E3<>"ZZZZ-ZZZZ-01",NOT(F3),G3<>100,H3=0,I3<>"INVOICED",I3<>"VOID",J3<>"VOID",J3<>"INVOICED"),"x","") |
發表於 2014-12-4 12:03
| 
