ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

Rounding ¨ç¼Æ

Rounding ¨ç¼Æ

¦³¤°»ò rounding ¨ç¼Æ¥i¥HÅý¨Ò¦p:

180.05
73.50
79.90
45.20

¥þ³¡¶i¦ì¬° 0.90

µª®×:
180.90
73.90
79.90
45.90

=TRUNC(A1)+0.9
ss

TOP

=int(A1)+0.9
ss

TOP

¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-11-2 00:06 ½s¿è

=floor(a1,1)+0.9
ss

TOP

¥»©«³Ì«á¥Ñ sunnyso ©ó 2013-11-2 00:23 ½s¿è

=roundup(a1,0)-0.1

³o­Ó¤½¦¡¹ï¾ã¼Æ·|¥X¿ù
ss

TOP

=rounddown(a1,0)+0.9
ss

TOP

¨Ó­Ó½ÆÂøªº
=IFERROR(LEFT(A1,FIND(".",A1))&"9", A1&".9")
ss

TOP

=IF(ISERR(FIND(".",A1)), A1 &".9",LEFT(A1,FIND(".",A1))&"9")
ss

TOP

=ROUNDUP(A1+1E-13,0)-0.1
ss

TOP

=CEILING(A1+1E-13,1)-0.1
ss

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD