Home » Posts

Split payment across months

To evenly distribute a payment or other amount over a given number of months, with a variable start month, you can use a simple formula together with the AND function and a bit of boolean logic. In the example shown, the formula in E5 is: =amount/months*AND(E4>=start,E4

April 14, 2025 · 1 min · 80 words · Holly Oneill

Table of Contents

AND will return TRUE only when both conditions are TRUE, and return FALSE in another other case.

This effectively zeros out calculations in months that fall outside the range of interest.

This works because during math operations, FALSE is coerced to zero, and TRUE is coerced to 1.

Excel AND function

Without named ranges

The formula in the example shown uses threenamed ranges.

AND returns TRUEonly if all the conditions are met.

If any conditions are not met, the AND function returns FALSE.

Without named ranges#

Without named ranges