Loop a formula in excel VBA
- by CEMG
I am trying to loop a formula in Column "D" until Column "B" doesn't have any more data.
The formula I am adding to Column "D" is :
IF(ISNUMBER(C5),C5,IF(C5A5/3+OFFSET(C5,-1,0))
,IF(C5<C6,((OFFSET(C5,1,0)-OFFSET(C5,-2,0))(A5/3)+OFFSET(C5,-2,0)),"")))
So the result I want in Column "D" once the macro is run is this:
A B C …