Need Formulas to move if a column is inserted

Hi

Or in P6 :-

=(PRODUCT(OFFSET($O$6,,-1,1,-3)%+1)-1)*100

and in R6 :-

=(PRODUCT(OFFSET($O$6,,-1,1,-12)%+1)-1)*100

both entered with Control-Shift-Enter.

hth