Hi

First formula
=MIN(25/0.5, widgets)
Second formula
==MIN(25/widgets, 0.50)
--

Regards
Roger Govier

wrote in message
...
I must meet $25 profit for every line item in my quote. I need a
formula which will automatically adjust the quantity being purchased
based on my per unit cost, and I also need a formula which will adjust
the cost per unit based on the original quantity. Example: 25
widgets @ gross profit $.50= $12.50..... first formula should adjust
number of widgets to meet $25.00 gross profit..... second formula
should adjust gross profit for 25 widgets. Is this possible?