在EXCEL表格中,怎样设置长*宽/1000000=面积,面积值不足0.3的按0.3算,大于0.3的以实际计算例如:856*356/100000=0.3047797*255/1000000=0.2008957*487/1000000=0.4660如何设置公式让0.2008等于0.3 ,大于0.3的就以实际计
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/12 09:57:07
![在EXCEL表格中,怎样设置长*宽/1000000=面积,面积值不足0.3的按0.3算,大于0.3的以实际计算例如:856*356/100000=0.3047797*255/1000000=0.2008957*487/1000000=0.4660如何设置公式让0.2008等于0.3 ,大于0.3的就以实际计](/uploads/image/z/2798382-30-2.jpg?t=%E5%9C%A8EXCEL%E8%A1%A8%E6%A0%BC%E4%B8%AD%2C%E6%80%8E%E6%A0%B7%E8%AE%BE%E7%BD%AE%E9%95%BF%2A%E5%AE%BD%2F1000000%3D%E9%9D%A2%E7%A7%AF%2C%E9%9D%A2%E7%A7%AF%E5%80%BC%E4%B8%8D%E8%B6%B30.3%E7%9A%84%E6%8C%890.3%E7%AE%97%2C%E5%A4%A7%E4%BA%8E0.3%E7%9A%84%E4%BB%A5%E5%AE%9E%E9%99%85%E8%AE%A1%E7%AE%97%E4%BE%8B%E5%A6%82%EF%BC%9A856%2A356%2F100000%3D0.3047797%2A255%2F1000000%3D0.2008957%2A487%2F1000000%3D0.4660%E5%A6%82%E4%BD%95%E8%AE%BE%E7%BD%AE%E5%85%AC%E5%BC%8F%E8%AE%A90.2008%E7%AD%89%E4%BA%8E0.3+%2C%E5%A4%A7%E4%BA%8E0.3%E7%9A%84%E5%B0%B1%E4%BB%A5%E5%AE%9E%E9%99%85%E8%AE%A1)
x){:gkϋ+-dZg
}ln^Nݯt^}C0}9wu 6?X7]OvAD^tݼ3[_[{鲦{fYiAM*60174225[ggd``aijeba$jbff 4ީg>m]tOu+!د┧6"&Hۉ?JX
{h@