Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Divide into three (excel 2003)

    Subject edited by HansV - "excel 2003" wasn't very descriptive.

    Hello,

    I have a formulat in many different cells that takes 1/3 of an amount and puts it in three different cells. My question is a as follows. If I put a number such as $25,000 it will display $8,333 in all of the three other cells. I would like to do a format so it can add to the $25,000. I tried adding a 1 at the end, but if I do that and the number is $30,000, it would give me $10,000 in the first two cells and $10,001 in the last cell which would add to $30,001. Any help would be great.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel 2003 (2003)

    Instead of putting 1/3 of the number in all three cells, put 1/3 of the number in the first two cells. In the third cell put the number minus the first two cells. You will probably also want to round all of the cells to a whole number. If 25,000 is in A1, then put this formula in the first two cells:

    <code>
    =ROUND(A1/3,0)
    </code>

    Then if those two formla are in C1 and C2, then put this formula in the thrid cell:

    <code>
    =A1-C1-C2
    </code>
    Legare Coleman

  3. #3
    Lounger
    Join Date
    Aug 2005
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: excel 2003 (2003)

    Thanks LegareColeman that works.

Posting Permissions

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