How to use goal seek without goal seek

[odonovanc]

Let's say I have this set of data:

Sales	100​
Expenses	20​
Net Income	80​
Profit %	80.0%​

Sales is cell A1 and the 80% is cell b4. Simple data set. If I want to goal seek what sales needs to be to make 90%, is there a way to do this without using goalseek?

 

[Eric W]

A little algebra:

Book1
	A	B	C
1	Sales	100	200
2	Expenses	20	20
3	Net Income	80	180
4	Profit %	80.0%	90%
Sheet3

Cell Formulas
Range	Formula
C1	C1	=C2/(1-C4)
C3	C3	=C1-C2

Change the value in C4, and C1 and C3 will calculate. C2 is assumed to be a fixed cost, because if it were a variable cost based on the number of sales, you'd always get the same percentage. But you can change the fixed cost (C2) if you want.