Forum Discussion
Formula with Variable Input
I am trying to write a formula that calls coefficients determined from different model datasets. Ideally, I would be able to toggle between the different model coefficients to see the updated results...
I'm quite sure it's possible, but it's hard to be more specific without seeing the spreadsheet (or a mockup of it) itself.
If you can't post directly to this forum, you could grant access to a copy of your file on OneDrive or in GoogleDrive (or the equivalent).
In the absence of that, let me refer you to the LET function for starters. It could be used to enable the kind of flexibility in using data from different data sets based on inputs such as you describe.