天气预报15天查询> 数码> round函数怎么用

round函数怎么用

更新时间: 2021-06-13 06:46:26     

1、打开Excel工作薄,点击选中单元格。

2、在选中单元格的公式栏内输入公式“=ROUND(D1,0)”(不包括双引号),该公式意思是求单元格小数点后零位数的四舍五入数值,按回车键计算。

3、由于单元格的数值为1.4,所以四舍五入后所求数值为1,这时按住该单元格右下角点向下拖。

4、这样就可以把单元格的公式填充入下面单元格。

关键词: round 函数 怎么

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-3501739/ | 耗时:0.0770 s | 内存:1.89 MB | 查询:6 | 缓存读取:4 写入:2 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=3501739 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=3501739 LIMIT 0,1
SELECT * FROM tbl_categories where CategoryID=90004 LIMIT 0,1
select * from tbl_Articles_sphinx where id=3501739 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(2373166,1121437,1086542,99009,753994,1102272,663937,376037,1092360,359714,84431,370399,372358,1091117,3261871,1083983,99107,1111136,1083131,365378,402833,1099915,3334296,1117021,1115671,391013,81285,3484936,3335998,376944) ORDER BY field (ArticleID,2373166,1121437,1086542,99009,753994,1102272,663937,376037,1092360,359714,84431,370399,372358,1091117,3261871,1083983,99107,1111136,1083131,365378,402833,1099915,3334296,1117021,1115671,391013,81285,3484936,3335998,376944)
SELECT ArticleID,Title FROM tbl_Articles where CategoryID=90004 ORDER BY ArticleID DESC LIMIT 20