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

##</code><code>##

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