Calculate sales price with 2 commission options and same net profit

A quicker way to get the value would be to use the What If Analysis on the Data tab.
1) Select Cell G6,
2) Select the What If Analysis icon,
3) Choose Goal Seek
4) Set Cell window should already display G6 (but type it in if it doesn't),
5) Type 237500 in the To Value window,
6) Place the cursor in the By Changing Cell window and select cell G11,
7) Press OK
If you are really needing this to be done by a formula, I would think that the formula should be placed in G11.
Let us know if you have any questions.

You mean like this?

	A	B	C	D
1	Price1	$ 250,000.00		B1: Input
2	Commission1	5%		B2: Input
3	Profit1	$ 237,500.00		B3: =B1*(1-B2)
4	Commission2	5.50%		B4: Input
5	Price2	$ 251,322.75		B5: =B3/(1-B4)
6	Profit2	$ 237,500.00		B6: =B5*(1-B4)

I will agree with JeteMc - Goal Seek is probably the easiest -- especially if this is a one time or occasional task.

If this is a frequent task that wants to be automated, I would solve the equation algebraically for the desired "unkown", then program the resulting formula into G11 (assuming G11 is the desired unkown). If I reverse engineered the algebra correctly, G4=C4+C4*C8-D4*D8+G11. Solving for any of these values/cells should be straightforward.

You're welcome.