读书人

怎么在excel中快速实现c1=(b2-b1)/b1,

发布时间: 2012-01-22 22:38:43 作者: rapoo

如何在excel中快速实现c1=(b2-b1)/b1,c2=(b3-b2)/b2,c3=(b4-b3)/b3.......
如题,急

[解决办法]
附加的VB宏代码如下:
Dim iIndex As Integer
Dim strRangeC As String
Dim strRangeCX As String

For iIndex = 2 To 3355
strRangeC = "D " + CStr(iIndex)

Range(strRangeC).Select
ActiveCell.FormulaR1C1 = "=(RC[-2]-R[-1]C[-2])/R[-1]C[-2] "
Next

读书人网 >OFFICE教程

热点推荐