Excel表格if函数

Question

6对应的数是0.8， 8对应的数是0.395，10对应的是0.617，怎样设置函数在a1输入6 8 10后在a2能得到相应的0.26 0.395 0.617

Answer 1

=LOOKUP(A1,{6,8,10;0.8,0.395,0.617})

Answer 2

=IF(A1=6,0.8,IF(A1=8,0.395,IF(A1=10,0.617,"")))

Answer 3

=if(A1=6810,"0.26"&"0.395"&"0.617","")

Answer 4

Excel表格IF函数怎么用？这个视频告诉你！