主题：EXCEL表LOOKUP公式在FOX表如何做？

=LOOKUP(C2,{0,97,101,105,110,115,120,125,130,135,140,145,150,155,160,165,170,175,180,185,190,195,200,205,210,215,220,225,230,241,256,271,286,301,316,331,351,371,385,401},{1.07,1.03,1,0.97,0.93,0.9,0.87,0.85,0.82,0.8,0.78,0.76,0.74,0.72,0.71,0.69,0.68,0.66,0.65,0.64,0.63,0.62,0.61,0.6,0.59,0.58,0.57,0.56,0.55,0.53,0.51,0.5,0.48,0.47,0.46,0.44,0.43,0.42,0.41,0.4})

上面是EXCEL表公式，在FOX 表中如何做？

我不懂lookup,请直接描述具体需求

当0<C2格<＝97时，该单元格＝1.07，当97<C2格<＝101时，该单元格＝1.03，照此类推。。。

LOOKUP公式前面大括号是数据区域，后面是选择数值。

表达式列的话，用iif嵌套：

 

iif(a<=97,1.07,iif(a<101,1.03,iif(a < 105,1.0,0)))

 

代码的话，if elseif elseif elseif .... end if

iif(a<=97,1.07,iif(a<101,1.03,iif(a < 105,1.0,0)))

如果套齐全部，看都看不清，有没有简单点的？

可以单独一个数据表，输入数据区域0,97,101,105,110,115,120,125,130,135,140,145,150,155,160,165,170,175,180,185,190,195,200,205,210,215,220,225,230,241,256,271,286,301,316,331,351,371,385,401

然后再输入数值

1.07,1.03,1,0.97,0.93,0.9,0.87,0.85,0.82,0.8,0.78,0.76,0.74,0.72,0.71,0.69,0.68,0.66,0.65,0.64,0.63,0.62,0.61,0.6,0.59,0.58,0.57,0.56,0.55,0.53,0.51,0.5,0.48,0.47,0.46,0.44,0.43,0.42,0.41,0.4

每次输入数据时都在这个数据表中进行搜索，得出范围值。

如何用做到生成的EXCELpiao据，仍保留EXCEL的公式，做到FOX与EXCEL两用？

好办法。

建一张对照表

 

 

值            起          止

1.07       0             97

1.03       98           101 

 

 

使用的时候删选一下

 

这样还能随时添加修改