Whereas that does not solve your issue directly, I usually go with the below approach when it comes to formulas.
1. Generally, I do not enter formulas with PAD but prepare an Excel template with an empty table and formulas in the table already.
2. I obtain the data from the source
3. I open an excel template, paste the data to the table, and let excel automatically expand the table and formulas - this way, I do not need to worry about manually adding the formulas with PAD.
4. I save the excel file as a new file.
I hope this help; if not - sorry for cluttering.
//edit
I'll add that this approach makes the solution more versatile/dynamic/easier to adapt in the case the formulas need to change:
A. Formula needs to change:
1. Formulas hardcoded in PAD approach --> when the logic change, you need to update Flow code
2. Excel template approach --> just update the template
B. More columns are added to the source data, shifting data used by formulas
1. Formulas hardcoded in PAD approach --> when the logic change, you need to update Flow code
2. Excel template approach --> just update the template
My approach is to add all formulas in the beginning of the file, this way I can paste any amount of data/columns in next columns, without overwriting those existing ones.
