Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Excel functions

Buy now

Download now

LITlib - Excel Power Functions Pack
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - Partition function
litLIB Help
Product pages :
Quick links:
help index

Numeric - Partition

=Partition(Number, StartNumber, StopNumber, Interval)

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


Determine in which interval the number 25 falls if the range of values is 1 to 100 in steps of 10.