Results 1 to 3 of 3

Thread: Filling cells based on user selected frequency??

  1. #1

    Filling cells based on user selected frequency??



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello all!

    I am trying to automate a payment schedule so that an estimated payment is matched to a specific period based on payment frequency (monthly, quarterly, etc) defined by me.
    Basically, I need a formula (that can be dragged down for as many periods required) that fills the payment coloums at specific intervals (every cell for monthly case, every 3 cells for quarterly case).
    I'd like to do this so that the process is automated and the only changes I make are the payment amount and the payment frequency.

    Any other ideas on how I could proceed?

    Thanks in advance

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,518
    Articles
    0
    Excel Version
    Excel 2016
    Can you supply a mock up spreadsheet of what you have and what your results would look like?


  3. #3
    Hello,

    Thanks - I managed to solve the issue with the MOD function.

    Cheer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •