Referencing Cell with Excel Function Name in Another Cell

[PDNY]

I'm creating a table with calculated mortgage payments with principal (PPMT) and interest (IPMT) functions in adjacent columns. I want to be able to change the cell contents at the top of the column, e.g. PPMT to IPMT, and have the cells below it reflect the changed function.

I've used CONCAT, but it only returns the text string and not the calculation.

=CONCAT(B1,"(Interest_rate/NPER,Period,Term*NPER,-Principal)")

NOTE: The IPMT and PPMT functions use same syntax.

Any suggestions? Thanks.

 

[PDNY]

Re: Referenicing Cell with Excel Function Name in Another Cell

RESOLUTION: Use VBA to create a function to evaluate the string as a formula:

• How to turn a string formula into a “real” formula

• https://www.mrexcel.com/forum/excel-questions/62067-eval-function-without-morefunc-add.html