International Futures Help System
AMAX and AMIN
IFs often bounds a variables computation with upper or lower limits. This serves a number of functions, all related to assuring reasonable behavior of the model under extreme conditions. For instance, denominators that might approach 0 are bound with the AMAX function so that they take on at least some specified number – the AMAX function returns the larger of the computed value and the number specified. Other computations are subject to the AMIN function so as to avoid becoming unreasonably large (such as probabilities that exceed 1) – the AMIN function returns the smaller of the computed value and the number specified.