Somewhat duplicate. For setting the formula, it looks like you should not set the value property. See here:
value
Write formula to Excel with Python