Excel中如何将公式计算出的数值四舍五入后只保留2位小数,之后再用这几个数值相加也只是小数点后2位相加例如:A列 B列 C列100 * 3.1131 = 3.11100 * 3.1144 = 3.11100 * 3.1153 = 3.12100 * 3.1143 = 3.11将C列的
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/14 15:15:40
![Excel中如何将公式计算出的数值四舍五入后只保留2位小数,之后再用这几个数值相加也只是小数点后2位相加例如:A列 B列 C列100 * 3.1131 = 3.11100 * 3.1144 = 3.11100 * 3.1153 = 3.12100 * 3.1143 = 3.11将C列的](/uploads/image/z/540198-54-8.jpg?t=Excel%E4%B8%AD%E5%A6%82%E4%BD%95%E5%B0%86%E5%85%AC%E5%BC%8F%E8%AE%A1%E7%AE%97%E5%87%BA%E7%9A%84%E6%95%B0%E5%80%BC%E5%9B%9B%E8%88%8D%E4%BA%94%E5%85%A5%E5%90%8E%E5%8F%AA%E4%BF%9D%E7%95%992%E4%BD%8D%E5%B0%8F%E6%95%B0%2C%E4%B9%8B%E5%90%8E%E5%86%8D%E7%94%A8%E8%BF%99%E5%87%A0%E4%B8%AA%E6%95%B0%E5%80%BC%E7%9B%B8%E5%8A%A0%E4%B9%9F%E5%8F%AA%E6%98%AF%E5%B0%8F%E6%95%B0%E7%82%B9%E5%90%8E2%E4%BD%8D%E7%9B%B8%E5%8A%A0%E4%BE%8B%E5%A6%82%EF%BC%9AA%E5%88%97+B%E5%88%97+C%E5%88%97100+%2A+3.1131+%3D+3.11100+%2A+3.1144+%3D+3.11100+%2A+3.1153+%3D+3.12100+%2A+3.1143+%3D+3.11%E5%B0%86C%E5%88%97%E7%9A%84)
xSR@~zd>HXNgzPH""?ZtETH]:{v+_g<@gg}$˻
i╡B:a
h}VrR.n~ $#VƉg@DD<Q
VGUКľѬnCIoGD K;
xhݹuvr