[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 495
  • Last Modified:

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
0
amkazen
Asked:
amkazen
  • 2
1 Solution
 
upcjdidnerCommented:
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now