天气预报 > 生活 > excel四舍五入后计算不准确怎么办
excel四舍五入后计算不准确怎么办
更新时间: 2021-05-03 14:16:14  

1、单击Excel文档左上侧的Office按钮;

2、打开Excel选项按钮,进入Excel选项页面;

3、点击Excel选项页面的“高级”;

4、下拉右侧垂直滚动条,找到“计算机此工作薄时”

5、将“将精度设置为所显示的精度”选中,然后单击“确定”即可。

关键词: excel 四舍五入 计算 准确 怎么办

excel四舍五入后计算不准确怎么办相关经验

天气预报

最新推荐

页面:/news/view-551204/ | 耗时:0.1896 s | 内存:2.11 MB | 查询:4 | 缓存读取:3 写入:0 | 加载文件:25
select * from tbl_Articles WHERE ArticleID=551204 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=551204 LIMIT 0,1
select * from tbl_Articles_sphinx where id=551204 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1123651,746647,758399,1095666,803331,97715,1111970,1126664,3315953,1126684,758005,430082,1127373,1114684,455357,1099657,1118154,539161,1126726,100949,1100701,643682,1121278,1101067,1138769,1096086,792595,1275220,589827,1132939) ORDER BY field (ArticleID,1123651,746647,758399,1095666,803331,97715,1111970,1126664,3315953,1126684,758005,430082,1127373,1114684,455357,1099657,1118154,539161,1126726,100949,1100701,643682,1121278,1101067,1138769,1096086,792595,1275220,589827,1132939)