Execl 公式=if(OR(C2=0.5*(C3+D3),C2=0.5*(C3+E3),C2=0.5*(C3+F3),C2=0.5*(C3+G3),C2=0.5*(C3+H3),C2=0.5*(D3+E3),C2=0.5*(D3+F3),C2=0.5*(D3+G3),C2=0.5*(D3+H3),C2=0.5*(E3+F3),C2=0.5*(E3+G3),C2=0.5*(E3+H3),C2=0.5*(F3+G3),C2=0.5*(F3+H3),C2=0.5*(G3+H3),C2,"")
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/25 21:09:07
![Execl 公式=if(OR(C2=0.5*(C3+D3),C2=0.5*(C3+E3),C2=0.5*(C3+F3),C2=0.5*(C3+G3),C2=0.5*(C3+H3),C2=0.5*(D3+E3),C2=0.5*(D3+F3),C2=0.5*(D3+G3),C2=0.5*(D3+H3),C2=0.5*(E3+F3),C2=0.5*(E3+G3),C2=0.5*(E3+H3),C2=0.5*(F3+G3),C2=0.5*(F3+H3),C2=0.5*(G3+H3),C2,](/uploads/image/z/2536211-11-1.jpg?t=Execl+%E5%85%AC%E5%BC%8F%3Dif%28OR%28C2%3D0.5%2A%28C3%2BD3%29%2CC2%3D0.5%2A%28C3%2BE3%29%2CC2%3D0.5%2A%28C3%2BF3%29%2CC2%3D0.5%2A%28C3%2BG3%29%2CC2%3D0.5%2A%28C3%2BH3%29%2CC2%3D0.5%2A%28D3%2BE3%29%2CC2%3D0.5%2A%28D3%2BF3%29%2CC2%3D0.5%2A%28D3%2BG3%29%2CC2%3D0.5%2A%28D3%2BH3%29%2CC2%3D0.5%2A%28E3%2BF3%29%2CC2%3D0.5%2A%28E3%2BG3%29%2CC2%3D0.5%2A%28E3%2BH3%29%2CC2%3D0.5%2A%28F3%2BG3%29%2CC2%3D0.5%2A%28F3%2BH3%29%2CC2%3D0.5%2A%28G3%2BH3%29%2CC2%2C%22%22%29)
Execl 公式=if(OR(C2=0.5*(C3+D3),C2=0.5*(C3+E3),C2=0.5*(C3+F3),C2=0.5*(C3+G3),C2=0.5*(C3+H3),C2=0.5*(D3+E3),C2=0.5*(D3+F3),C2=0.5*(D3+G3),C2=0.5*(D3+H3),C2=0.5*(E3+F3),C2=0.5*(E3+G3),C2=0.5*(E3+H3),C2=0.5*(F3+G3),C2=0.5*(F3+H3),C2=0.5*(G3+H3),C2,"")
Execl 公式
=if(OR(C2=0.5*(C3+D3),C2=0.5*(C3+E3),C2=0.5*(C3+F3),C2=0.5*(C3+G3),C2=0.5*(C3+H3),C2=0.5*(D3+E3),C2=0.5*(D3+F3),C2=0.5*(D3+G3),C2=0.5*(D3+H3),C2=0.5*(E3+F3),C2=0.5*(E3+G3),C2=0.5*(E3+H3),C2=0.5*(F3+G3),C2=0.5*(F3+H3),C2=0.5*(G3+H3),C2,""))
这个公式错在哪里?
若出现平均数,则显示C2的值,否则不显示任何内容.
Execl 公式=if(OR(C2=0.5*(C3+D3),C2=0.5*(C3+E3),C2=0.5*(C3+F3),C2=0.5*(C3+G3),C2=0.5*(C3+H3),C2=0.5*(D3+E3),C2=0.5*(D3+F3),C2=0.5*(D3+G3),C2=0.5*(D3+H3),C2=0.5*(E3+F3),C2=0.5*(E3+G3),C2=0.5*(E3+H3),C2=0.5*(F3+G3),C2=0.5*(F3+H3),C2=0.5*(G3+H3),C2,"")
or公式少了一个括号 ) ,公式末尾的括号多了一个 )
即将末尾的 ) 移位到 ,c2,"") 的前面就可以了.