在B列中输入什么函数,能由A自动得到B列的数值呢?数据表格详见补充
发布网友
发布时间：2024-10-01 09:28
共2个回答
热心网友
时间：3分钟前
=IF(A1<1,"",LOOKUP(A1,{1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,25,30,35},{0.35,0.34,0.33,0.32,0.31,0.3,0.29,0.28,0.26,0.24,0.22,0.2,0.18,0.16,0.14,0.12,0.11,0.1,0.09,0.08,0.07,0.06,0.05}))
热心网友
时间：5分钟前
用excel吧这些数据画成图，然后用添加趋势线的方法可以得到拟合的方程，我看你给的数据并不能连续，还是画成图后根据图分段得出各段的函数吧
