A is the original price

B is the factor by which I multiply the original price to increase it

C is the new figure which is reached after multiplying (1+B2)*A2

D is the costs related to that job (I enter these manually on a separate sheet within the workbook)

E if the profit (C-D)

Note: I use a factor in B because when I increase the price, then I have to increase several parts of the job by the same percentage so I multiply each part by this factor to increase the price of each by the same percentage.

Now what I would like to do is if E2<300 then have excel automatically change the price for me so that E2=300.

I put the following formula into the B2: =IF(E2<300,1+(300-E2)/A2,0), but this produced a circular reference and doesn't calculate properly. Can someone please help me figure out how to do this?