Solved

Goal Seek and Tax rates & Excel Formula

Posted on 2010-08-19
3
484 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

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.

Question has a verified solution.

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

Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
Outlook Free & Paid Tools
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

839 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