求下边公式怎么列?

异乡人13579 |浏览1021次
收藏|2019/01/20 07:09

满意回答

2019/01/20 07:19

假设β在单元格A1:=MAX(IF(A1>0,34,42),50-ABS(A1*100)*IF(A1>0,2,1))

尊尼CKin

其他回答(1)
  • =LOOKUP(A1,{-9000000000,-0.07,-0.06,-0.05,-0.04,-0.03,-0.02,-0.01,0,0.01,0.02,0.03,0.04,0.05,0.06,0.07,0.08},{42,43,44,45,46,47,48,49,50,48,46,44,42,40,38,36,34})
    回答于 2019/01/20 07:49
0人关注该问题
+1

 加载中...