Excel Help
Results 1 to 7 of 7

Thread: Excel Help

  1. #1
    All-Star
    Points: 42,707, Level: 63
    Level completed: 82%, Points required for next Level: 243
    Overall activity: 21.0%
    Achievements:
    25000 Experience PointsVeteran
    farminclone's Avatar
    Join Date
    Nov 2009
    Posts
    1,723
    Points
    42,707
    Level
    63
    Thumbs Up
    Received: 258
    Given: 25

    Excel Help

    I need a total sum of money split 3 ways, but I want the 3 way split to always add up to the sum exactly. Anything I can do for this?

    Thanks



  2. #2
    Bench Warmer
    Points: 7,345, Level: 25
    Level completed: 59%, Points required for next Level: 205
    Overall activity: 4.0%
    Achievements:
    Veteran5000 Experience Points

    Join Date
    Nov 2009
    Location
    Polk City, IA
    Posts
    319
    Points
    7,345
    Level
    25
    Thumbs Up
    Received: 2
    Given: 6

    Re: Excel Help

    What version of Excel? In Excel 2010 you could try going to File - Options - Advanced. Under the 'When calculating this workbook' section set the 'Set precision as displayed' option to enabled.



  3. #3
    Hall-Of-Famer
    Points: 93,657, Level: 95
    Level completed: 27%, Points required for next Level: 1,393
    Overall activity: 6.0%
    Achievements:
    Veteran50000 Experience Points
    Incyte's Avatar
    Join Date
    Apr 2007
    Posts
    4,046
    Points
    93,657
    Level
    95
    Thumbs Up
    Received: 376
    Given: 65

    Re: Excel Help

    How is the sum being split?


    “Science investigates; religion interprets. Science gives man knowledge, which is power; religion gives man wisdom, which is control. Science deals mainly with facts; religion deals mainly with values. The two are not rivals. They are complementary.”

    Martin Luther King Jr.

  4. #4
    All-Star
    Points: 42,707, Level: 63
    Level completed: 82%, Points required for next Level: 243
    Overall activity: 21.0%
    Achievements:
    25000 Experience PointsVeteran
    farminclone's Avatar
    Join Date
    Nov 2009
    Posts
    1,723
    Points
    42,707
    Level
    63
    Thumbs Up
    Received: 258
    Given: 25

    Re: Excel Help

    Quote Originally Posted by Incyte View Post
    How is the sum being split?
    1/3, 1/3, 1/3



  5. #5
    All-Star
    Points: 42,707, Level: 63
    Level completed: 82%, Points required for next Level: 243
    Overall activity: 21.0%
    Achievements:
    25000 Experience PointsVeteran
    farminclone's Avatar
    Join Date
    Nov 2009
    Posts
    1,723
    Points
    42,707
    Level
    63
    Thumbs Up
    Received: 258
    Given: 25

    Re: Excel Help

    Quote Originally Posted by blizzisu View Post
    What version of Excel? In Excel 2010 you could try going to File - Options - Advanced. Under the 'When calculating this workbook' section set the 'Set precision as displayed' option to enabled.
    This worked, thanks a lot, I appreciate the help.



  6. #6
    Addict
    Points: 151,237, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 4.0%
    Achievements:
    50000 Experience PointsVeteran
    longtimeclone's Avatar
    Join Date
    Dec 2009
    Location
    Up north
    Posts
    7,901
    Points
    151,237
    Level
    100
    Thumbs Up
    Received: 94
    Given: 43

    Re: Excel Help

    Do you have this is in 3 separate columns? Could you do 2 rounddowns and 1 roundup functions?



  7. #7
    Bench Warmer
    Points: 7,345, Level: 25
    Level completed: 59%, Points required for next Level: 205
    Overall activity: 4.0%
    Achievements:
    Veteran5000 Experience Points

    Join Date
    Nov 2009
    Location
    Polk City, IA
    Posts
    319
    Points
    7,345
    Level
    25
    Thumbs Up
    Received: 2
    Given: 6

    Re: Excel Help

    An example of a calculation that isn't working the way you want it to would be helpful as well.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
  • TV: Cyclones.tv
  • HOOPS: Iowa State vs. Mississippi Valley State
  • December 31, 2014
  • 06:00 PM