+ Reply to Thread
Results 1 to 6 of 6

if statement to calculate distribution of funds

  1. #1
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    196

    if statement to calculate distribution of funds

    I'm trying to create a spreadsheet to calculate a distribution of funds after the sale of two properties.
    in the attached spreadsheet B2 is a constant value and so is A2
    C2 will change depending on the sale price of the property.
    In short this is what I want to do.
    There are 3 siblings, my sister will get lot 5 from the sale of the estate, the lot is valued at 150K
    My brother and I will split the profits of the land sale B2 or portion will be 87.5K as you can see my sister will have the largest share.
    The sale of the next property lot 1 has not happened yet.
    I'm trying to create a formula to say "if the total sale value of lot 1 (C2) and land sale from Brad (B2) were to exceed the $150k that was originally given to my sister, then the profit should be divided equally among the three of us.
    For example At point of property sale, Judy gets lot 5 valued at 150k, Matt and Dave split the 175k which equals 87.5k leaving Matt and Dave 62.5k short of being equal to the value of Judy's share.
    The sale of lot 1 if it were 125k we would all break even, Judy would get none of the profits, Dave and Matt would split the 125K and all three would have a value of 150k.
    The value is likely to be more than 125k so any excess would then have to be distributed evenly among the three.
    I hope that makes sense.

    Please see attached.
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: if statement to calculate distribution of funds

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Does this work?

  3. #3
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    196

    Re: if statement to calculate distribution of funds

    Not quite, but how about this, can you help me write a formula for this.
    If c2>a2 then c2-a2/3

  4. #4
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: if statement to calculate distribution of funds

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can put whatever text you want between the "". That part of the formula is what happens if C2 is not greater than A2.

    Also, this formula calculates C2 minus A2, and then the answer is divided by three. I assume this is the order that you require.

  5. #5
    Forum Contributor
    Join Date
    05-18-2012
    Location
    Chicopee, Ma
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    196

    Re: if statement to calculate distribution of funds

    Almost there, can you help me out with one last thing?
    I have a formula that is written =if(c2>a2,c2-a2)/3
    I would like to add -a2 after the formula but can't seem to do it without getting an error.
    Could you please help?

    Thanks

  6. #6
    Forum Contributor
    Join Date
    04-02-2012
    Location
    Ohio
    MS-Off Ver
    Excel 2010
    Posts
    452

    Re: if statement to calculate distribution of funds

    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Is this what you need?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Distributing Funds Until Exhausted
    By pkew22 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-07-2013, 05:25 PM
  2. pension funds using VBA
    By code_noob in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-23-2012, 01:19 PM
  3. skewness of a given distribution - how to calculate?
    By Nafrtiti in forum Excel General
    Replies: 0
    Last Post: 02-12-2012, 04:55 AM
  4. Equal Distribution Of Funds Question
    By Brandens in forum Excel General
    Replies: 1
    Last Post: 11-15-2011, 03:10 PM
  5. [SOLVED] How do I calculate the cumulative distribution function
    By macrohunter in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-17-2006, 01:45 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1