Create formula from multistep sheet

[gianmatt]

Apologies if post title isn't properly worded. I have a sheet in my workbook that calculates tax. There are several rows, and some rows depend on the value from an earlier row. Bottom line, there are two input parameters, in cells A1 and A2, and the answer is generated in cell A10.

This can only be used manually, i.e. I have to enter the two values every time I want to calculate tax. Is it possible to make a callable function out of this? I have another sheet that contains a list of values that correspond to the A1 and A2 parameters in my tax calculator. For each set of values, I'd like to automatically "call" my tax calculator and get the result.

 

[Joe4]

If you had Excel 365, you could create a LAMBDA function, which allows you to create re-usable functions in Excel (see: LAMBDA function - Microsoft Support).

Without 365, your best bet maybe to create your own custom User Defined Function in VBA.

However, where is the complexity in the process? Are you sure it cannot be done with simple functions (maybe you just don't know how)?
If you could post a few examples of what you are working with and explain how the amount is determined, perhaps we can better assist you.

 

[gianmatt]

It's OK - I learned how to write my own VBA function to pass the parameters and return the value. It works!

 

[Joe4]

Excellent!
Glad you were able to create your own UDF!

 

[gianmatt]

I realized that it can actually be condensed into a very long expression, but it was more fun to write the function.

 

[Joe4]

I realized that it can actually be condensed into a very long expression, but it was more fun to write the function.

Yep, as long as whoever is using it can use VBA and is sure to enable it, it does make things a bit easier!
In Excel 365, you could do it without VBA using a new LAMDBA function.