COLUMN D: Dropdown record of values

COLUMN E: IF operate returning completely different values relying on COLUMN D contents

I’ve the performance described above working correctly. My downside is that I would like the IF operate in COLUMN E to return a working components moderately than a worth.

Proper now the IF operate solely returns the precise components textual content moderately than utilizing the components itself throughout the cell. I am assuming that it’s because the IF operate can solely present values, not formulation, as outputs.

Is there a greater method or operate I can use to insert a totally completely different, operational components into COLUMN E relying on the worth listed in COLUMN D?

Your assistance is appreciated.

EDIT: An instance of my downside might be discovered on the next sheet:

https://docs.google.com/spreadsheets/d/1m_-rLniq-il7jL0ilWZWxh4cYq65DW2V2uQwtFgQLLA/edit?usp=sharing