主题：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 表中如何做？

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

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

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两用？

主表的单价是输入，关联表则根据主表的单价以及主表的重量的大小自动输入，如主表的单价是8.5，重量是97斤，则关联表的单价＝8.5+1.03，希望有一点简单的办法，并且上述的｛｝、｛｝内的数据可以随时修改。

不懂，如何做？

对不起！不过师父你的指点真的很有用！