Results 1 to 6 of 6

Thread: Distribute Debt Across Time Period Split A Number Based On Another Split Ratio

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 05-27-2013, 11:21 PM #3
    Rick Rothstein
    Rick Rothstein is offline
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    If I understand what you want correctly, put this formula in cell D5 and copy it across to H5...

    =IF($C5>SUM(D4:$H4),D4,MAX(0,D4+$C5-SUM(D4:$H4)))
    Last edited by Rick Rothstein; 05-27-2013 at 11:48 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. 10$ For VBA Code Split Data To Multiple Workbook Based On Unique Values In A Column
    By jamilm in forum Hire A Developer
    Replies: 17
    Last Post: 05-22-2013, 11:58 PM
  2. Split Data in Table To Multiple Rows Based On Delimited Text In Columns
    By nick5_86 in forum Excel Help
    Replies: 4
    Last Post: 05-01-2013, 09:49 PM
  3. Split Row Data In To Multiple Columns Based On Delimiter
    By cjjn in forum Excel Help
    Replies: 2
    Last Post: 03-05-2013, 07:34 AM
  4. Split data
    By jan in forum Excel Help
    Replies: 19
    Last Post: 08-12-2012, 02:50 AM
  5. Split data based on criteria
    By Mahesh.sreekakulam in forum Excel Help
    Replies: 3
    Last Post: 06-08-2012, 09:30 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