Note: In order to use the spreadsheet examples, you need to download Business Functions
|Collar (Amt, Minimum, Maximum)|
|Collars a number|
|This function makes sure that the number returned is between Maximum and Minimum. If Maximum or Minimum are zero, however, that constraint is inactive. In other words, Collar just does a Cap or a Floor if one or other of Maximum or Minimum is zer|
|...Collar...||The function is restrained to a maximum and a minimum|
If the value of either Minimum or Maximum is zero, it is ignored ie no cap or floor is assigned.