Forum Discussion
QWeelon
Sep 21, 2021Brass Contributor
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. ...
- Sep 21, 2021
See the attached version; it uses XLOOKUP.
HansVogelaar
Sep 21, 2021MVP
See the attached version; it uses XLOOKUP.
- QWeelonSep 22, 2021Brass Contributor
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!
- HansVogelaarSep 22, 2021MVP
See the attached version.
- QWeelonSep 22, 2021Brass Contributor
Hi again,
Double checked the results and and got an error of 1 cell for certain values. See attached file for test algorithm.
This formula is lightyears from my Excel comprehension so I'd never be able to figure out how and if it can be tweaked.
Thanks again!