Results 1 to 7 of 7

Thread: Questions about the logic of division
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Questions about the logic of division

    I would like to divide the number above

    is this possible with formula or macro ?
    Example file :http://www.filedropper.com/liste

  2. #2
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,753
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Questions about the logic of division

    Here's your sheet, but your question isn't clear. What are you trying to do exactly?

    Sayfa1

    ABCDEFGHIJKLMNOPQ
    1Question Answer
    2x1010151032 x1010151032
    31.part 1.part3343111/4 +
    42.part 2.part3343111/4 +
    53.part 3.part22421 1/4 -
    64.part 4.part2232 1/4 -
    7 000000 1010151032

    Spreadsheet Formulas
    CellFormula
    B7=SUM(B3:B6)
    C7=SUM(C3:C6)
    D7=SUM(D3:D6)
    E7=SUM(E3:E6)
    F7=SUM(F3:F6)
    G7=SUM(G3:G6)
    K7=SUM(K3:K6)
    L7=SUM(L3:L6)
    M7=SUM(M3:M6)
    N7=SUM(N3:N6)
    O7=SUM(O3:O6)
    P7=SUM(P3:P6)


    Excel tables to the web >> Excel Jeanie HTML 4
    Last edited by Scott Huish; Oct 4th, 2016 at 05:26 PM.
    Office 2010/365

  3. #3
    New Member
    Join Date
    May 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Questions about the logic of division

    Hello Mr.

    Firstly thanks for your turnback,

    My question is;
    Cell B2 = 10

    How can I split totaly 4 pieces that number like this?
    B3=3
    B4=3
    B5=2
    B6=2


    Second table is a finished splitted table for example...
    Last edited by Baggwell; Oct 5th, 2016 at 10:09 AM.

  4. #4
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,753
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Questions about the logic of division

    In B3:
    =-INT(-B2/4)

    In B4:
    =-INT(-(B$2-SUM(B$3:B3))/(-(ROWS($A$1:A1)-4)))

    Copy down to B6 and copy across. You can use a custom number format to hide 0 if you wish.
    [=0]""

    Sayfa1

    ABCDEFG
    1Question
    2x1010151032
    31.part334311
    42.part334311
    53.part224210
    64.part223200
    7 1010151032

    Spreadsheet Formulas
    CellFormula
    B3=-INT(-B2/4)
    B4=-INT(-(B$2-SUM(B$3:B3))/(-(ROWS($A$1:A1)-4)))
    B5=-INT(-(B$2-SUM(B$3:B4))/(-(ROWS($A$1:A2)-4)))
    B6=-INT(-(B$2-SUM(B$3:B5))/(-(ROWS($A$1:A3)-4)))


    Excel tables to the web >>
    Office 2010/365

  5. #5
    New Member
    Join Date
    May 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Questions about the logic of division

    Hello, good idea ı tried it

    But there is a little problem I think so, can you check it the picture please?

    Screenshot by Lightshot

  6. #6
    MrExcel MVP
    Moderator
    Scott Huish's Avatar
    Join Date
    Mar 2004
    Location
    Oregon
    Posts
    19,753
    Post Thanks / Like
    Mentioned
    5 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Questions about the logic of division

    It's impossible to tell what your formulas are from a picture. Could you at least provide a downloadable link like you did before?
    Office 2010/365

  7. #7
    New Member
    Join Date
    May 2014
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Questions about the logic of division

    Its possible I made it with your help

    This is finish file okay : http://www.filedropper.com/liste_1

    Thank you for helping

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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