Splitting Amount into equal payments across several cells



I am needing some help trying to figure out a formula that will take an amount due and split it across a determined number of months. I would also like it to return a "due date" based on a "start date".

Total Amount: $77,760.00

# of Months: 6

Start Date: 2/1/2021

I would like to have the amount due ($77,760) split between 6 payments. Each payment will populate in its corresponding month (payment cells) and return the due date. As you can see I did not get very far and all of the formulas I came across factored in interest, which we do not use. Thank you all in advance!!

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    Are you able to copy/paste your exact formula directly from your sheet? It shouldn't be doing that as the first portion of the IF is comparing the number in the [# of months/ ...] column to how many columns you have moved over. If the number of months is greater than or equal to the number of columns we have moved to the right, then it should populate. If the number is less than how many columns we have moved over, then the output should be blank.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!