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 :
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)

litLIB