+ Reply to Thread
Results 1 to 3 of 3

Need help about rounding result from formula result.

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    440

    Need help about rounding result from formula result.

    Hi,

    I have a sheet with an amount to input, and the amount will be divided by the # of account the member has. However, if it falls into example, 2000$ for 3 accounts, it will be 666.67$ x 3 = 2001$. I will need something a macro or formula to auto adjust that if the total is 2001$, it will add or minus 1 or 2 of the 3 accounts by 1 or 2 penny. 666.67, 666.67 and 666.66 (this scenario). If the total is 1000$, it will be 333.33, 333.33, 333.33, so it 999.99$ which is missing 1 penny, then it will add 1 penny to any of the 3 accounts. But some member has 9 accounts, so the # of account will varies.. Is there a way to do that to add the balance to the first account.??

    Here is an example of the 2 possibilities spreadsheet with formula that I am using.

    TEST.xlsm

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    6,288

    Re: Need help about rounding result from formula result.

    In each of the first accounts, your need to use a formula like

    =ROUND(Total Entry/#of accts,2)

    Then you must use a different formula for the last account: Total Entry minus the sum of the other rounded values.
    Bernie Deitrick
    Excel MVP 2000-2010

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Canada
    MS-Off Ver
    Excel 2007
    Posts
    440

    Re: Need help about rounding result from formula result.

    I figure out that too, thanks.

+ 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] Rounding formula result
    By cabusiness in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-01-2012, 10:36 PM
  2. Rounding Formula Result to nearest $0.05
    By hicountry in forum Excel General
    Replies: 3
    Last Post: 08-29-2010, 11:45 PM
  3. [SOLVED] Rounding a formula result to read thousands from millions.
    By R Champ in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 PM
  4. [SOLVED] Rounding a formula result to read thousands from millions.
    By N Harkawat in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-06-2005, 02:05 PM
  5. Rounding a formula result to read thousands from millions.
    By R Champ in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 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