ªð¦^¦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 : ¥@¤W¦³¨â¥ó¨Æ¤£¯àµ¥¡G¤@¡B§µ¶¶ ¤G¡B¦æµ½¡C
ªð¦^¦Cªí ¤W¤@¥DÃD