Excel 數值運算-IF、ROUNDUP、ROUNDDOWN函數. ... 步驟1:點取B2儲存格輸入公式「=IF(MOD(A2,10)<=2,ROUNDDOWN(A2,-1),IF(MOD(A2, 10)<=7,ROUNDUP(A2 ...
確定! 回上一頁