Hiya,
So I'm trying to use a spreadsheet to do reverse tax calculations and am trying to use a macro to achieve this by having it increase the gross salary (Cell F9) until the net salary (Cell B15) equals the desired number (Cell E3).
I have taken a stab at writing the code however, I'm quite novas when it comes to VBA so it hasn't worked very well. The code I have tried is:
However it doesn't stop increasing when it meeting the criteria.
I will be super grateful for any help anyone can give me!
I have attached my workbook for context.
Bookmarks