先看效果图

在用的什么公式实现的

主要 用的函数： index ， linest, ln  ,exp 

公式从上到下，依次：

=INDEX(LINEST($B$2:$B$11,$A$2:$A$11),1) =INDEX(LINEST($B$2:$B$11,$A$2:$A$11),2)

=EXP(INDEX(LINEST(LN($B$2:$B$11),$A$2:$A$11),2)) =INDEX(LINEST(LN($B$2:$B$11),$A$2:$A$11),1) ********************************************************* =INDEX(LINEST($B$20:$B$31,LN($A$20:$A$31)),1) =INDEX(LINEST($B$20:$B$31,LN($A$20:$A$31)),2)

=EXP(INDEX(LINEST(LN($B$20:$B$31),LN($A$20:$A$31)),2)) =INDEX(LINEST(LN($B$20:$B$31),LN($A$20:$A$31)),1) ********************************************************* =INDEX(LINEST($B$37:$B$49,$A$37:$A$49^{1,2,3},TRUE,TRUE),1,1) =INDEX(LINEST($B$37:$B$49,$A$37:$A$49^{1,2,3},TRUE,TRUE),1,2)

=INDEX(LINEST($B$37:$B$49,$A$37:$A$49^{1,2,3},TRUE,TRUE),1,3) =INDEX(LINEST($B$37:$B$49,$A$37:$A$49^{1,2,3},TRUE,TRUE),1,4)

demo例子下载。https://pan.baidu.com/s/1tFGE6eqpMNYSXWPH-WQqxw