# Find a formula to produce \$0.00

1. ## Find a formula to produce \$0.00

Enclosed attachment is set up to find the difference between the Selling Price of a house and the Purchase Price of a second house.
By entering a value in I25, it calculates the Net Difference in D25. This seems OK to find various scenarios.

I would like to have a formula to show a value to put in I25 that would produce \$0.00 in D25.

The problem I have in trying to calculate a \$0.00 answer is the Property Purchase Tax in I20, as it varies with the Purchase Price Offer in D19.

2. ## Re: Find a formula to produce \$0.00

Have you looked at Solver?

https://www.excel-easy.com/data-analysis/solver.html

3. ## Re: Find a formula to produce \$0.00

Or perhaps you could try "Goal Seek" as you only wish to change one value to get target value

paint1.jpg

Then you click ok

paint2.jpg

and click ok a last time

Alf

4. ## Re: Find a formula to produce \$0.00

For a one time or rare computation, I will agree that Solver and/or Goal Seek are probably the easiest way to do this.

If this is something you need to do frequently, I would suggest that the easier solution would be to do the algebra to find the direct solution. The algebra for something like this is sometimes tedious but rarely difficult. What seems to throw people off is, just as you said, you get "x" in two (or more) different parts of the equation and they have forgotten how to handle that situation. A quick algebra refresher should be enough to remember how to do those: https://www.purplemath.com/modules/solvelin3.htm

I haven't looked in detail. If you are interested, let us know where you get stuck on the algebra, and we'll help as best we can.

5. ## Re: Find a formula to produce \$0.00

Thanks to the prompt replies. Both solutions work well, and I will attempt solution 3 from Mr.Shorty as well, as a multiple solution would be great.

7. ## Re: Find a formula to produce \$0.00

Marked SOLVED right after my morning coffee

8. ## Re: Find a formula to produce \$0.00

You are welcome.

Thanks for feed back and rep.

Alf

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1