?
Solved

Goal Seek and Tax rates & Excel Formula

Posted on 2010-08-19
3
Medium Priority
?
493 Views
Last Modified: 2012-06-27
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
Comment
Question by:amkazen
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
upcjdidner earned 2000 total points
ID: 33480235
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
 

Author Comment

by:amkazen
ID: 33480895
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
 

Author Comment

by:amkazen
ID: 33480950
never mind...I figured it out..opened my eyes and saw column E..    THANKS!
0

Featured Post

Learn Veeam advantages over legacy backup

Every day, more and more legacy backup customers switch to Veeam. Technologies designed for the client-server era cannot restore any IT service running in the hybrid cloud within seconds. Learn top Veeam advantages over legacy backup and get Veeam for the price of your renewal

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

649 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question