Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic field adjustment
I have a business where I buy things are one place and sell them at another, I am limited by two things: 1. my maximum amount of cash to pay for something before i resell it: (Max Cash) 2. the capcity of my truck (Max Capcity) I have a "Total" field that uses the "price" and "quantity" fields to sum up a total (price*quantity=Total). I also have a "max capcity" and a "max cash" field which shows the maxium "quantity" I can fit into a truck and the max cash I can spend at one time. so... I want my quantity field to automatically adjust when it is higher than my max capcity field so I don't buy more than I can haul. ALSO I want my quantity field to automatically adjust when the TOTAL field is higher than my "Max Cash" rate so i don't attempt to buy more than I can afford thank you for even attempting this, seems like it is impossible based on my limited knowledge -- Sabrick ------------------------------------------------------------------------ Sabrick's Profile: http://www.excelforum.com/member.php...o&userid=32385 View this thread: http://www.excelforum.com/showthread...hreadid=521483 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
automatic field adjustment
Your problem is more like a formula issue than programming
Solution is along the llines of A B C D E F Qty Price Total Max Cash Max Cap Qty to Buy 12 100 =A*B 1,000 50 =MIN(A,INT(D/B),E) Row numbers missing from formulas If you enter more in column A than you can afford or than you can carry column F will show the limiting number Nick "Sabrick" wrote: I have a business where I buy things are one place and sell them at another, I am limited by two things: 1. my maximum amount of cash to pay for something before i resell it: (Max Cash) 2. the capcity of my truck (Max Capcity) I have a "Total" field that uses the "price" and "quantity" fields to sum up a total (price*quantity=Total). I also have a "max capcity" and a "max cash" field which shows the maxium "quantity" I can fit into a truck and the max cash I can spend at one time. so... I want my quantity field to automatically adjust when it is higher than my max capcity field so I don't buy more than I can haul. ALSO I want my quantity field to automatically adjust when the TOTAL field is higher than my "Max Cash" rate so i don't attempt to buy more than I can afford thank you for even attempting this, seems like it is impossible based on my limited knowledge -- Sabrick ------------------------------------------------------------------------ Sabrick's Profile: http://www.excelforum.com/member.php...o&userid=32385 View this thread: http://www.excelforum.com/showthread...hreadid=521483 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 2007 - field "Update automatic links at open" does not work | Excel Discussion (Misc queries) | |||
Name field - automatic calculate | Excel Discussion (Misc queries) | |||
automatic adjustment | Excel Discussion (Misc queries) | |||
Automatic row height adjustment | Excel Discussion (Misc queries) | |||
Automatic column width adjustment | Excel Worksheet Functions |