I have a collection of rudimentry formulas which I have generated, and want to have these all combined into 1 overarching formula.
What would be the best route to do so?
each formula looks for a specific piece of data and then populates accordingly. So nothing to out there.
All suggestions are welcomed.
Keep the separate formulas you have created. To combine them, create a formula that calls each of them to get you the data you're looking for. Note that to combine the data as text, you'll need to convert any numeric or date data to string using ToText(). If you're final result needs to be a number, you'll have to convert any strings to numbers.