Hi folks --
I have several formulae that different only by a sign or single cell, and would like to instruct Excel how to handle each different case.
For example ...
Taking a row with the values below, where each discrete part of the formula is broken up into its own cell ...
and then using CONCAT on the above range to produce a formula.
Except, the formula is inert when produced as the result of a CONCAT function and cannot be referenced by other cells as a formula, even though it displays as such.
I want to be able to discretely separate my variables, write a set of formulae to instruct Excel how to fill those variables based on the results of a VLOOKUP, CONCAT them into a formula, and then nest them into an IFS function with other iterations of CONCAT arrays. I'll have about 50 unique instances of CONCAT'd formulae in the nested IFS.
Can this be done? How can I do it? Is CONCAT the right way to approach this, and if no, what would be a better way?
Thank you, take care and be well!
Warmly,
~Haven.-
Bookmarks