Understanding Formula

[spectraflame]

Can anyone explain this formula and what it is doing? The OFFSET is confusing me.

=IF(OR(ISBLANK(M67),ISBLANK(C67)),"",IF(OR(ISBLANK(N67),Q67=0,Q67=-1),(L67-M67)*100/D67,((L67-M67)-(AVERAGE(OFFSET(O67,(Q67+1),0)/300*N67,OFFSET(O67,(Q67+(IF(OFFSET(A67,Q67,0)="SEED",0,1))),0)/300*N67)))*100/D67))

 

[Chrisdontm]

OFFSET is basically "defining a range".
A range can be many cells, or even one cell.
The benefit to using it is that it can easily be dynamic.
For example: use a count formula to tell it how many rows to go down.
So to define the range it has a starting point. (I like to use $A$1)
The next part after the comma will be how many rows down or up from that starting point.
Then how many columns over do you want to actually start your range at.
Then you say the height, which again could be a formula.
Then the width.
If you omit any of the parts it will basically use zero.

Look through your formula to visualize what range it is referencing.
At times you have to use an OFFSET inside an OFFSET.

I hope this helps, at least in the OFFSET part of the formula.

 

[spectraflame]

Thank you for the explanation.