litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Numeric - Partition

Syntax:
=Partition(Number, StartNumber, StopNumber, Interval)

Description:
Returns a string that indicates where the number occurs in the interval.

Number : the number to consider
StartNumber : Start number of the series of values that is partitioned
StopNumber : End number of the series of values that is partitioned
Interval : Size of the interval in which the series of values is partitioned

Example:
Determine in which interval the number 25 falls if the range of values is 1 to 100 in steps of 10.
=Partition(25,1,100,10)