Excel技巧PPT课件.pptVIP

函數 Functions * 1. 絕對值 (|x|) 2. 整數 =INT(18/5) =INT(3.65) =INT(–4.3) 3 3 –5 3. 去除尾數(小數) =TRUNC(3.65) =TRUNC(–4.3) =TRUNC(123.456) =TRUNC(123.456,1) =TRUNC(123.456,2) =TRUNC(129.456,–1) 3 –4 123 123.4 123.45 120 truncate截尾 =INT(123.456) 準確至1位小數 (0.1) 準確至2位小數 (0.01) 準確至十位 (10) =ABS(1–4) =ABS (–2) 3 #NAME? Error - no blank 函數 Functions * 4. 餘數 (a%b) 5. 四捨五入 =MOD(19,4) =MOD(–15,4) =MOD(15,–4) =MOD(–15,–4) 3 1 –1 –3 餘數remainder of 19/4 =ROUND(125.678,0) =ROUND(125.678,1) =ROUND(125.678,2) =ROUND(125.678,–1) =ROUND(125.678,–2) 126 125.7 125.68 130 100 準確至1 (個位) 1位小數 (0.1) 2位小數 (0.01) 十位 10 百位 100 1