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 |
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 |