#EXCEL語法應用

Excel 公式	計算結果
ROUND(四捨五入)
=ROUND(-12345.6789, 2)	        -12345.68
=ROUND(-12345.6789, 1)	        -12345.7
=ROUND(-12345.6789, 0)	        -12346
=ROUND(-12345.6789, -1)	-12350
=ROUND(-12345.6789, -2)	-123


#### ROUNDDOWN(無條件捨去)
=ROUNDDOWN(399*0.75,0)          299