COLUMN D: Dropdown record of values
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: