By SCFormulatext function is used to document formula of a cell in sheet or it will return formula used in cell as shown below.
Syntac:=Formulatext(cell id)
will reveal formula behind the cell.
This blog is about working with data by using different tools Excel ,Python, Access Power automate etc .