Ive seen the following article on how to create parameters and allow user input to crete what if analyses.
The output appears linear. I.e If investment is increased by 5%, sales increase 5%.
I was hoping the expand on this with the following. How would I create the functionality to refer to an investment v revenue table. i.e a non linear curve so for example if investment (Y) is increased by 5%, the revenue increases by X%. The x and y would be defined in a reference table. The attached image is graphical representation of this table.