Goal Seek and Tax rates & Excel Formula

Hi,  This week has been tough.  Here is another formula that has me stumped and I am looking for help.  I have a tax rate applied to labor used to determine the amount of taxes.  The labor amount is not known and can only be determined by "backing" into it. A tax rate change occurred, doubling, , and there are more planned changes (could be decreases or increases) for the future, but the formula "broke", causing the "backed" into labor amount to be cut in half.  Can anyone figure out how to change the formula to account for any posisble tax rate changes, up or down? Test-2010-08-19.xls..OS is XP and Excel 2003..soon to be upgraded to Windows 7 and Excel 2007
amkazenAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
upcjdidnerConnect With a Mentor Commented:
See the attached spreadsheet.

You need extra columns, which you can hide later. This is because you used the original tax rate and amount to backsolve for a labor column you didn't have, so you can't change those original values.

I did a Copy/Paste Special...Values to get a new Labor column (as static value) that won't change when you adjust the tax rate.

I hope these point you in the right direction.
Labor-and-Taxes-with-Additional-.xls
0
 
amkazenAuthor Commented:
I am looking at your spreadsheet....I see now I was not clear....I was trying to get the amount in colmn K, based on using goal seek on column J....June 18 I had $431k in column K, but one week later, after the rate change, I had $211,782, about a 50% drop, even though there wa sno corresponding 50% drop in employees or labor..Sorry for the confusion..
0
 
amkazenAuthor Commented:
never mind...I figured it out..opened my eyes and saw column E..    THANKS!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.