Probably should be under programming but I am looking for a way to do this without writting code.

What I have is a worksheet that does a few complicated calculations based on very few input cells. The calculations involve getting the maximum and minimum of columns, average and a few conditional sums.
The result is one number, put on cell A2.
The main variable is input on cell A1.
The area used for calculations is roughly C1:J100
All other data variables are on the A column A3:A12
Now what I want is to create a custom function that relates those two cells. Say, if I call Func(5) it should go put 5 in A1 and return the value of A2.
I utterly want to create a table with those A1, A2 values but it would be extremely complicated to do all those calculations in a row and autofill.
If this can be done with one cell (A1) can it be done with multiple input variables (A3:A12). It will still have to output one number only.
Thank you all in advance for your help.