Change a cell value, based upon other numbers in other cells, also with minimum value.

[Skiny]

Ok, pretty confused here.

I've attached a picture of a basic spreadsheet, so hopefully you can see what I am trying to accomplish:

192896371_Capture_123_1lo.JPG

What I am trying to do, is force the PURCHASE column to change it's value, so that the PROFIT column will result in being a percentage of the SELL column. The PROFIT column would also need to have a minimum value of 50, so that would also impact the number in the PURCHASE column. If that makes any sense.

For example, in the first row, cell A2 would need to change from 75 to 50. This would make cell C2 (PROFIT) also become 50, as B2-A2 = 50.


Is it possible to do this with a spreadsheet?