=PARTITION
The PARTITION function splits a number into a list of integers whose total sum equals the original number, based on a specified divisor.
Syntax
Section titled “Syntax”=PARTITION(NumberToBePartitioned; Divisor)Parameters
Section titled “Parameters”NumberToBePartitioned – The total number you want to break into parts.
Divisor – The value used as the repeating unit for partitioning the number.
How It Works
Section titled “How It Works”-
Takes the original number.
-
Repeatedly subtracts the divisor from it.
-
Creates a list of repeated divisor values.
-
Adds a final remainder value so the full sum equals the original number.
-
Returns the result as a semicolon-separated list of integers.
Usage Notes
Section titled “Usage Notes”-
Formula functions are case sensitive and must be written in ALL CAPS.
-
The final value in the list may be smaller than the divisor (the remainder).
-
Useful for breaking totals into evenly distributed chunks.
-
Commonly used in allocation, batching, and scheduling workflows.
-
Ensures no loss of value: all outputs always sum back to the original number.
Examples
Section titled “Examples”=PARTITION(100; 31)Returns
Section titled “Returns”31; 31; 31; 7=PARTITION(100; 32)Returns
Section titled “Returns”32; 32; 32; 4Keywords
Section titled “Keywords”PARTITION, split number, divide into parts, allocation, batching, remainder handling, integer list, workflow formulas, formula function