round/roundup/rounddown

Warning: include_once(/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/top_msg.php): failed to open stream: No such file or directory in /home/users/2/moriya-h5/web/confrage/excel/function/round/round.html on line 22

Warning: include_once(): Failed opening '/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/top_msg.php' for inclusion (include_path='.:/usr/local/php/5.6/lib/php') in /home/users/2/moriya-h5/web/confrage/excel/function/round/round.html on line 22

Warning: include_once(/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/menu.php): failed to open stream: No such file or directory in /home/users/2/moriya-h5/web/confrage/excel/function/round/round.html on line 29

Warning: include_once(): Failed opening '/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/menu.php' for inclusion (include_path='.:/usr/local/php/5.6/lib/php') in /home/users/2/moriya-h5/web/confrage/excel/function/round/round.html on line 29

トップページ > Excel > round/roundup/rounddown

初版2009/12/13：最終更新日2009/12/13

指定した桁数で四捨五入する

=ROUND(数値,桁数)
桁数：四捨五入後の桁数を指定します。
小数点の位置が0となり、左側へ-1(1の桁），-2(10の桁）、右側へ1(小数第1位)，2(小数第2位)

指定した桁数で切り上げる

=ROUNDUP(数値,桁数)
桁数：切り上げ後の桁数を指定します。
小数点の位置が0となり、左側へ-1(1の桁），-2(10の桁）、右側へ1(小数第1位)，2(小数第2位)

指定した桁数で切り捨てる

=ROUNDDOWN(数値,桁数)
桁数：切り捨て後の桁数を指定します。
小数点の位置が0となり、左側へ-1(1の桁），-2(10の桁）、右側へ1(小数第1位)，2(小数第2位)

HOME

Warning: include_once(/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/side_bar.php): failed to open stream: No such file or directory in /home/users/2/moriya-h5/web/confrage/excel/function/round/round.html on line 92

Warning: include_once(): Failed opening '/home/sites/heteml/users/m/o/r/moriya-h5/web/confrage/bin/side_bar.php' for inclusion (include_path='.:/usr/local/php/5.6/lib/php') in /home/users/2/moriya-h5/web/confrage/excel/function/round/round.html on line 92