Results 1 to 7 of 7

Thread: Excel Help

  1. 05-24-2012, 01:41 PM #1
    farminclone
    farminclone is offline
    All-Star
    Points: 32,585, Level: 55
    Level completed: 58%, Points required for next Level: 465
    Overall activity: 0%
    Achievements:
    25000 Experience PointsVeteran     farminclone's Avatar
    Join Date
    Nov 2009
    Posts
    1,246
    Points
    32,585
    Level
    55

    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
    Reply With Quote Reply With Quote
  2. 05-24-2012, 01:55 PM #2
    blizzisu
    blizzisu is offline
    Walk On
    Points: 5,327, Level: 21
    Level completed: 56%, Points required for next Level: 223
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    Join Date
    Nov 2009
    Location
    Polk City, IA
    Posts
    213
    Points
    5,327
    Level
    21
    Send a message via AIM to blizzisu

    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.
    Reply With Quote Reply With Quote
  3. 05-24-2012, 02:01 PM #3
    Incyte
    Incyte is offline
    Pro
    Points: 70,505, Level: 82
    Level completed: 45%, Points required for next Level: 945
    Overall activity: 1.0%
    Achievements:
    Veteran50000 Experience Points     Incyte's Avatar
    Join Date
    Apr 2007
    Posts
    3,249
    Points
    70,505
    Level
    82

    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.
    Reply With Quote Reply With Quote
  4. 05-24-2012, 02:03 PM #4
    farminclone
    farminclone is offline
    All-Star
    Points: 32,585, Level: 55
    Level completed: 58%, Points required for next Level: 465
    Overall activity: 0%
    Achievements:
    25000 Experience PointsVeteran     farminclone's Avatar
    Join Date
    Nov 2009
    Posts
    1,246
    Points
    32,585
    Level
    55

    Re: Excel Help

    Quote Originally Posted by Incyte View Post
    How is the sum being split?
    1/3, 1/3, 1/3
    Reply With Quote Reply With Quote
  5. 05-24-2012, 02:06 PM #5
    farminclone
    farminclone is offline
    All-Star
    Points: 32,585, Level: 55
    Level completed: 58%, Points required for next Level: 465
    Overall activity: 0%
    Achievements:
    25000 Experience PointsVeteran     farminclone's Avatar
    Join Date
    Nov 2009
    Posts
    1,246
    Points
    32,585
    Level
    55

    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.
    Reply With Quote Reply With Quote
  6. 05-24-2012, 02:06 PM #6
    longtimeclone
    longtimeclone is offline
    Addict
    Points: 167,644, Level: 100
    Level completed: 0%, Points required for next Level: 0
    Overall activity: 24.0%
    Achievements:
    50000 Experience PointsVeteran     longtimeclone's Avatar
    Join Date
    Dec 2009
    Location
    On the road
    Posts
    6,281
    Points
    167,644
    Level
    100

    Re: Excel Help

    Do you have this is in 3 separate columns? Could you do 2 rounddowns and 1 roundup functions?
    Reply With Quote Reply With Quote
  7. 05-24-2012, 02:09 PM #7
    blizzisu
    blizzisu is offline
    Walk On
    Points: 5,327, Level: 21
    Level completed: 56%, Points required for next Level: 223
    Overall activity: 0%
    Achievements:
    Veteran5000 Experience Points
    Join Date
    Nov 2009
    Location
    Polk City, IA
    Posts
    213
    Points
    5,327
    Level
    21
    Send a message via AIM to blizzisu

    Re: Excel Help

    An example of a calculation that isn't working the way you want it to would be helpful as well.
    Reply With Quote Reply With Quote
« Philli Sixers Dancers | Fresh Prince »

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

All content owned by CycloneFanatic.com - All rights reserved 2005-09. By viewing this website you agree to the Terms of Service, Site Rules and Legal Disclaimer. The words, views, images and opinions expressed or provided by users do not reflect the opinions or views of CycloneFanatic.com or Iowa State University. The names, words, symbols, and graphics representing Iowa State University are trademarks and copyrights of the University protected by the trademark and copyright laws of the United States of America and other countries and are used on this web site under license from the University. Original site design, premise & construction by Jeremy Lind.

  • Football
  • Iowa State vs. Northern Iowa
  • August 31, 2013
  • 07:00 PM

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19