Forum Discussion
Solved
Calculating taxes backwards
Dear community, here's one for you math lovers! Basically, what I want to do is calculate backwards how much tax I have to pay to acquire a set amount after tax. See attached file for table. ...
See the attached version; it uses XLOOKUP.
See the attached version; it uses XLOOKUP.
Very nice! Thank you!
Is there a way to further augment this formula and make it even more general and safe for future expansion of the table? As you might have figured out, I will have to add another column for next year, and the next year and so on.
The input formula could be assumed to be the first day of the current month, using the formula below:
=TODAY()-DAY(TODAY())+1
Thank you again!