Forum Discussion
Formula variations linked to a dropdown list
Riny_van_Eekelen has given you, as he said, an extremely simplified example of how a table can be used to vary those parameters based on some descriptor or label for the type of program in question.
You're to be commended for desiring to make these all manageable in one basic database (a fancy word for "file"). At the same time, while it can make things easier to see at a higher level to have them all combined, it is important to think through all the parameters, all of the consistencies between the various programs as well as the differences. And then a table such as Riny_van_Eekelen gave you, but perhaps/probalby more extensive could be used to manage a lot of the particulars.
So for us to be able to really help, it really would be good if you could upload a sample or two of the spreadsheets you're working with, along with as complete description of the goals for this consolidation.