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.
OK, try this (confirmed with Ctrl+Shift+Enter:
=U162+INDEX(C3:R488,MATCH(INDEX(A3:A488,MATCH(U162,A3:A488-INDEX(C3:R488,0,MATCH(U159,C1:R1,0)))),A3:A488,0),MATCH(U159,C1:R1,0))
Thank you, the formula is close but not flawless. In this case both of your formulas are good enough for my intentions. I'm very grateful for your time and effort!
Thank you!
Have a good week-end!
Thank you!
Have a good week-end!