Hi all,

I have made a long function (multiple if variables, spanning a field of input numbers and percentages) to calculate the commission for a sales manager. Now what I am left with is basically one input, X, and one output, Y. Whenever I enter a department sales level (X) I get the correct commission (Y).

What I would like is to make use of this so that I can create a long list of various turnover numbers and show both in a table and with a graph how the commission would change with different amounts of sales. Is there anyway I can pull this off? Define the left column as X and have excel use the function to get a unique Y for each level?