$Excel->Range($mycell)->{Formula} = "=your formula here"