I have a tax calculation for state and federal that requires several steps and vlookups which would be difficult to code as a single formula.
Is there a way to call a sheet or a cell within a sheet to perform the steps and return the final value without using VBA?
Ie: I have a list of various income and want to calculate tax for each one. The income is "passed" to the tax calculation "subroutine" and return the tax calculated result
year income Calculated tax from steps and formulae below
1 50000 1200
2 55000 1250
3 59000 1290
.....
Tax calculation
step 1
step 2
step 3
....
Bookmarks