1绝对值（x）.docVIP

1 絕對值FUNCTIONS函數 RESULTS結果 MEANING意義 =ABS(–4) 3 absolute value =ABS (–2) #NAME? no blank 2 整數 =INT(18/5) =INT(3.65) 3 integer part =INT(–4.3) –5 3 去除小數 =TRUNC(3.65) 3 Truncate =TRUNC(–4.3) –4 =TRUNC(123.456) 123 =INT(123.456) =TRUNC(123.456,1) 123.4 1位小數 (0.1) =TRUNC(123.456,2) 123.45 2位小數 (0.01) =TRUNC(129.456,–1) 120 十位 4 餘數=MOD(19,4) 3 餘數remainder of 19/4 =MOD(–15,4) 1 =MOD(15,–4) –1 =MOD(–15,–4) –3 5 四捨五入ROUND, ROUNDUP, ROUNDDOWN =ROUND(125.678,0) 126 126 125 準確至1 =ROUND(125.678,1) 125.7 125.7 125.6 1位小數 (0.1) =ROUND(125.678,2) 125.68 125.68 125.67 2位小數 (0.01) =ROU