COLUMN D: Dropdown list of values
IF function returning different values depending on COLUMN D contents
I have the functionality described above working properly. My problem is that I want the
IF function in COLUMN E to return a working formula rather than a value.
Right now the
IF function only returns the actual formula text rather than using the formula itself within the cell. I'm assuming that this is because the
IF function can only provide values, not formulas, as outputs.
Is there a better approach or function I can use to insert a completely different, operational formula into COLUMN E depending on the value listed in COLUMN D?
Your help is appreciated.
EDIT: An example of my problem can be found on the following sheet: