roundå½æ°å°æå®çå°æ°ä½æ°è¿è¡åèäºå
¥è¿ç®çç»æãé¤æ°å¼å¤ï¼ä¹å¯å¯¹æ¥æè¿è¡èå
¥è¿ç®
roundå½æ°çè¯æ³æ¯ï¼ROUND(number,num_digits)ï¼å³ï¼Roundï¼æ°å¼ï¼ä¿ççå°æ°ä½æ°)
ä¾å¦ï¼
=ROUND(2.649, 1) å° 2.649 åèäºå
¥å°ä¸ä¸ªå°æ°ä½ (2.6)
=ROUND(-5.574, 2) å° -5.574 åèäºå
¥å°ä¸¤å°æ°ä½ (-5.57)