Results 1 to 5 of 5

Loan amount spreading in months columns after putting the number of installments automatic

Threaded View

  1. 06-17-2018, 02:02 PM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,702

    Re: Loan amount spreading in months columns after putting the number of installments autom

    In E7:P10
    Formula: copy to clipboard 
    =IF(COLUMNS($E$1:E$1)<=ROUNDUP($C7/$D7,0),MAX((COLUMNS($E$1:E$1)*$D7<=$C7)*$D7,MOD($C7,$D7)),"")


    Will also take care of uneven payments.


    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
    M
    N
    O
    P
    6
    Name
    Total Advance amount
    Agreed Instlments
    Jan
    Feb
    Mar
    Apr
    May
    Jun
    Jul
    Aug
    Sep
    Oct
    Nov
    Dec
    7
    abc
    10000
    2000
    2000
    2000
    2000
    2000
    2000
    8
    xyz
    15000
    3000
    3000
    3000
    3000
    3000
    3000
    9
    pqr
    25000
    6000
    6000
    6000
    6000
    6000
    1000
    10
    edf
    55000
    20000
    20000
    20000
    15000
    Last edited by FlameRetired; 06-17-2018 at 02:47 PM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Tricky Excel problem: spreading amounts over user inputted number of columns
    By hyperionloop in forum Excel General
    Replies: 1
    Last Post: 01-14-2017, 03:06 AM
  2. [SOLVED] Calculating number of months given a set amount of days
    By jacobus1231 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-12-2016, 05:35 AM
  3. Spreading targets over 12 months as whole numbers, without a +/- remainder
    By Robioto in forum Excel General
    Replies: 1
    Last Post: 06-13-2014, 03:13 AM
  4. spreading a project value over a number of months based on order month & project duration
    By Steve.Jarvis in forum Excel General
    Replies: 1
    Last Post: 05-02-2014, 03:05 PM
  5. How to calculate the total number of months to repay the loan & the interest rate per mo?
    By Lubu in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-02-2014, 12:27 AM
  6. Spreading budget over months
    By Scott_Hall in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2014, 04:13 PM
  7. Need a formula to calculate the number of months to pay off a loan
    By kv in forum Excel General
    Replies: 2
    Last Post: 08-02-2005, 04:05 PM

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1