User Defined Function: Nested Ifs?

I'm created a User Defined Function that looks up and applies the correct tax bracket based on certain inputs. I'm quit new to the user defined function/VBA world but and pretty excited to figure this stuff out. In essence, I'm just trying to embed a dozen vlookup tables in the code, and have the correct one chosen based on choosing the right arguments.

Here's what I have

Please Login or Register  to view this content.

Hello indianagreg,

I wouldn't do this with a UDF at all, not touching VBA, even. This gets way too complex and hard to maintain. Look at how you have errors in your data already in the sample you posted.

Please Login or Register  to view this content.

Shouldn't the numbers both be the same, either 8376 or 9376?

Anyway, this is done much easier and with a lot less typing by creating a few lookup tables and a handful of formulas. See attached. I changed the values from status to status, so you can see that the lookups work. Plug in your own numbers and see.

Other factors for the calculation can easily be added, a few more rows in the lookup table for another parameter, another Index/Match function to look up the value.

With VBA you would be writing pages and pages of code again.

cheers,