可以把你的公式贴出来。
if 只能用在函数中,可以使用
IIF
如果是在编辑自定义函数,测试按钮将无效,(模拟过滤很快就加上)
长度无限制,可随意写或加回车,如:
复制内容到剪贴板
代码:
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) +
IIF(RHZ mod 11 in [2,3,4,5,6],1,0) 可以随意镶套
复制内容到剪贴板
代码:
IIF(123=
IIF(
1=IIF(RHZ mod 11 in [2,3,4,5,6],1,0)
,123,456)
,789,568
)[em10]
[
本帖最后由 自由计算 于 2008-5-17 08:59 编辑 ]