=IF((MID(H49,1,1)="-"),M49*10000-$G$46*10000,IF((MID(H49,1,1)>"0"),$G$46*10000-M49*10000,IF((MID(I49,1,1)="-"),M49*10000-$I$46*10000,IF((MID(I49,1,1)>"0"),$I$46*10000-M49*10000,IF((MID(J49,1,1)="-"),$K$46*100-M49*100,IF((MID(J49,1,1)>"0"),M49*100-$K$46*100,""))))))
各位好:
小弟想將以上函數錄成巨集執行,但出現「太複習,無法錄製。」,請各位指教!謝謝! |