请帮忙检测一下EXCEL的语句,=IF(AND(ROUND(SUM(ROUND(C43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(F43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(I43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(L
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/20 11:44:32
![请帮忙检测一下EXCEL的语句,=IF(AND(ROUND(SUM(ROUND(C43,IF(基本信息!$B$26=](/uploads/image/z/4791891-3-1.jpg?t=%E8%AF%B7%E5%B8%AE%E5%BF%99%E6%A3%80%E6%B5%8B%E4%B8%80%E4%B8%8BEXCEL%E7%9A%84%E8%AF%AD%E5%8F%A5%2C%3DIF%28AND%28ROUND%28SUM%28ROUND%28C43%2CIF%28%E5%9F%BA%E6%9C%AC%E4%BF%A1%E6%81%AF%21%24B%2426%3D%22%E5%88%86%E4%BD%8D%EF%BC%882%E4%BD%8D%E5%B0%8F%E6%95%B0%EF%BC%89%22%2C2%2C0%29%29%2CROUND%28F43%2CIF%28%E5%9F%BA%E6%9C%AC%E4%BF%A1%E6%81%AF%21%24B%2426%3D%22%E5%88%86%E4%BD%8D%EF%BC%882%E4%BD%8D%E5%B0%8F%E6%95%B0%EF%BC%89%22%2C2%2C0%29%29%2CROUND%28I43%2CIF%28%E5%9F%BA%E6%9C%AC%E4%BF%A1%E6%81%AF%21%24B%2426%3D%22%E5%88%86%E4%BD%8D%EF%BC%882%E4%BD%8D%E5%B0%8F%E6%95%B0%EF%BC%89%22%2C2%2C0%29%29%2CROUND%28L)
请帮忙检测一下EXCEL的语句,=IF(AND(ROUND(SUM(ROUND(C43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(F43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(I43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(L
请帮忙检测一下EXCEL的语句,
=IF(AND(ROUND(SUM(ROUND(C43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(F43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(I43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(L43,IF(基本信息!$B$26="分位(2位小数)",2,0)),IF(基本信息!$B$26="分位(2位小数)",2,0)-ROUND(O43,IF(基本信息!$B$26="分位(2位小数)",2,0))=0),ROUND(SUM(ROUND(D43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(G43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(J43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(M43,IF(基本信息!$B$26="分位(2位小数)",2,0))),IF(基本信息!$B$26="分位(2位小数)",2,0))-ROUND(P43,IF(基本信息!$B$26="分位(2位小数)",2,0))=0),"","Rounding check!")
请帮忙检测一下EXCEL的语句,=IF(AND(ROUND(SUM(ROUND(C43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(F43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(I43,IF(基本信息!$B$26="分位(2位小数)",2,0)),ROUND(L
大概可以写成这样:
=IF(AND(SUM(ROUND(N(INDIRECT({"C43","F43","I43","L43"})),IF(基本信息!$B$26="分位(2位小数)",2,0)))=ROUND(O43,IF(基本信息!$B$26="分位(2位小数)",2,0)),SUM(ROUND(N(INDIRECT({"D43","G43","J43","M43"})),IF(基本信息!$B$26="分位(2位小数)",2,0)))=ROUND(O43,IF(基本信息!$B$26="分位(2位小数)",2,0))),"","Rounding check!")
数组公司,要按Ctrl+Shift+Enter结束