Computes the bin for a value using the provided lower bounds.
input value (required) The value to place into the defined bins. Input values can be a number, date or string.
cutoff 1 (required) The lower bounds to compare the value against. Cutoff values must be of the same type as the input value. The first cutoff entered indicates the lower bounds of bin 2. Any value lower than cutoff 1 is placed in bin 1. Bin 2 is inclusive of the entered cutoff.
cutoff 2+ (optional) Additional cutoffs create additional bins. The total number of bins is one more than the number of provided lower bounds.
NOTE: To ensure you get the expected results, make sure your cutoffs are listed sequentially.
These functions return well-known mathematical constants or implement common arithmetic functions.