Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits
I am doing a fairly easy programme on excel. It is a catchment runoff, and
evaporation calculator. But i would like to place a limit on a cell, and have that exess go into another column, is this possible? EG 75 rainfall, soil can hold only 10mm more. SO 10mm INFILTRATES, ie that cell should have a limit of the max soil moisutre, the other 65mm RUNOFF's and thats a different column. ANYBODY PLEASEEEEEEEEEE!!!! lol |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Limits
You need a Workbook_Change event macro for that. The code you would write
in that macro should first check that the change occurred in a cell within the range you want. Then the code would check the value of what you entered, and if it exceeds some value the code would reduce the value to what you want and insert the difference, or whatever you want, into some other column. Writing the code is left to the student. HTH Otto "Student" wrote in message ... I am doing a fairly easy programme on excel. It is a catchment runoff, and evaporation calculator. But i would like to place a limit on a cell, and have that exess go into another column, is this possible? EG 75 rainfall, soil can hold only 10mm more. SO 10mm INFILTRATES, ie that cell should have a limit of the max soil moisutre, the other 65mm RUNOFF's and thats a different column. ANYBODY PLEASEEEEEEEEEE!!!! lol |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Limits of MINV matrix function | Excel Worksheet Functions | |||
List vector using upper and lower limits | Excel Discussion (Misc queries) | |||
Pivot table Limits? | Excel Discussion (Misc queries) | |||
How do I easily draw in Excel the Upper and Lower limits of a con. | Charts and Charting in Excel | |||
How do i set up if function with more than level limits? | Excel Worksheet Functions |