主题：请教逻辑函数if中那个符号是"包含"?

请教逻辑函数if中那个符号是"包含"?

"Instr"

请老师回复!
如何实现在一个单元格输入1+1,在另一个单元格等于2?

egd文件下载

谢谢!
我觉得易表函数的实例太少,老师你有关于函数的学习资料吗?我想学习这方面的知识!

帮助文件是最好的学习资料

请介绍一下Like,8个比较函数的后三个,
谢谢!

-=-=-=- 以下内容由 hcy1185 在 2011年04月08日 10:17pm 时添加 -=-=-=-
我觉得"定额含量"表的"金额"列刷新公式还得改,按同一定额子目的所有行,"类别"列中没有"机械"时,设置条件,

-=-=-=- 以下内容由 hcy1185 在 2011年04月08日 10:19pm 时添加 -=-=-=-
If([定额编号] >= 1205 And [定额编号] <= 1236 Or [定额编号] >= 2109 And [定额编号] <= 2140,If([类别] = "材料费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","材料") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","材料费%")/100),If([类别] = "机械费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","材料") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","机械费%")/100),[含量] * [定额材料!单价/元])),If([类别] = "材料费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","材料") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","材料费%")/100),If([类别] = "机械费%",Sumfor("定额含量","金额","定额编号","=",[定额编号],"类别","=","机械") * (Sumfor("定额含量","含量","定额编号","=",[定额编号],"类别","=","机械费%")/100),[含量] * [定额材料!单价/元])))
这个公式虽然计算正确,但"定额编号"列的属性设置字符型便于使用补充定额