1. Calculation functions
2. All Functions
3. Time and Date Functions

The SPREAD function divides a value evenly over a number of time periods.

## Syntax

SPREAD(Value to divide, Number of time periods)

## Arguments

 Argument Data type Description Value to divide Number The value to be spread across the time periods. Number of time periods Number The number of time periods to spread the value over.

The SPREAD function returns numeric values.

## Constraints

• You cannot have a decimal value for the number of time periods.
• The time range for the values to be spread and the line item that contains your result, must match. Any formula that conflicts with this rule will be rejected.
• A non-time series function, if used as a subexpression of this function, must use the same time range as the line item to which the formula is applied. Combining time series functions and non-time series functions with a differing time range can return an unexpected result or an error message. For more information, see Time Ranges and Time Series Functions.

SLN

## Examples

 Jan 19 Feb 19 Mar 19 Apr 19 May 19 Jun 19 Value to spread 10 000 0 4000 0 0 0 Spread SPREAD(Value to spread, 4) 2500 2500 3500 3500 1000 1000

From the example above, the value 10000 is entered into the Value to spread cell for Jan 19 and is spread over the next 4 months.

When an additional value of 4000 is added in Mar 19, the value is also spread over the next 4 months. The overlapping months are summed to provide a final figure, as long as the Summary Method for the row is set to SUM.