Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula calculation | Excel Worksheet Functions | |||
Calculation / Formula HELP | Excel Worksheet Functions | |||
formula calculation | Excel Discussion (Misc queries) | |||
calculation in an if formula | Excel Worksheet Functions | |||
i need help with a calculation formula... | Excel Worksheet Functions |