Skip navigation

Pardee Logo International Futures at the Pardee Center

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.