Hi BlakeSkate,

Your'e absolutely right, too many "its" and I apologize.

BlakeSkate,

Marcelo Branco, and anyone else...
Please reference the table below where the text "Stock" is in Cell A1, and the text "Adjusted Target" is in D9.

Here are the formulas; Every other cell simply contains text or values, no formulas.

Cell B7: =B1+B4-B6

Cell B9: =B7/B5

Cell D4: =IF(B9>1.5,B4*(1-0.5),B4*(1+0.5))

Cell D7: =D1+D4-D6

Cell D9: =D7/D5

Essentially, I have an opportunity to adjust the purchase order (In this example, 8,000 pcs as seen in B4) up or down 50%) (Opportunity to adjust from Columns C:D)

D4 formula recognizes that the original target of 1.71 (CellB9) is higher than 1.5 so the formula reduces 8000 pcs by 50% resulting in 4000 pcs as seen in D4.

I would like for the formula to reduce by a maximum of 50% but not to go below the new target of 1.6.

Cell D9 has the same formula as Cell B9 meaning that if you replaced 4000 in D4 with 8000 it would result in 1.71 as well. (Same as B9)

BlakeSkate, the Adjusted Target is in fact 1.6 so please disregard my original statement "as close to 1.6 as possible"

No need for the spreadsheet to display the percentage difference.

The value I seek in D4 is 6,500

Explanation: Although Cell D4 has an opportunity to reduce B4 by 50% the cell only reduces by 23% in order to meet the 1.6 target.

I hope this further explains my objective, and I'm happy to answer any additional questions.

Thank you in advance!

Stock | 16000 | Stock | 16000 |

| | | |

| | | |

Purchase Order | 8000 | Adjusted Qty. | 4000 |

Average | 14000 | Average | 14000 |

Outgoing Orders | 100 | Outgoing Orders | 100 |

Ending Stock | 23900 | Ending Stock | 19900 |

| | | |

Target | 1.71 | Adjusted Target | 1.42 |

<tbody>

</tbody>