Solved

Goal Seek and Tax rates & Excel Formula

Posted on 2010-08-19
3
482 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
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
upcjdidner earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

863 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now