• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

reverse calculation

Alina_T

Member
Hi! I have an excel file where I need to reach a gross income starting from the net. I use goal seek but something is wrong in the formula and I can't understand what I'm doing wrong. If I put the gross directly in the yellow cell, the calculation is applied correctly, the formulas seem correct. But when I use goal seak it doesn't work all the time - in some cases, it works correctly, in others it doesn't. Taxes are applied depending on the gross income that I should reach. therefore I think that the formula for the net income, the blue cell, is entered incorrectly or incompletely. Please help!
Thank you!
 

Attachments

  • pfa 2022-2023_calculation.xlsm
    22.9 KB · Views: 6
Back
Top