Creating a formula in a specific cell

[brycemaurice]

I have built my workflow to function as I need except for one part.

I need to create a formula inside cell C32 of the attached file, that reads = -sum(c2:c31,c33:c37). 

How can I do this?

[FinnCharlton]

Hi @brycemaurice ,

You can do this by using the 'Overwrite Sheet Or Range' functionality of the output data tool.

Create a single row and column in Alteryx containing your formula, in your case  =-sum(c2:c31,c33:c37)

In the output data tool, choose the Excel file you want change, select the sheet and the range C32:C32:

In the output data configuration, make sure 'Overwrite sheet or range' is selected and 'Skip Field Names' is ticked:

Hope this helps!

[binuacs]

@brycemaurice Another option to write in the same input file, in this case you need to create a new string field and update the formula in the 32 row for this field then output to excel