+ Reply to Thread
Results 1 to 9 of 9

Round formula and percentage multiplication error

Hybrid View

  1. #1
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,655

    Re: Round formula and percentage multiplication error

    Here the problem is if you change the multiplication values with any formula, those values will be changed and you will get the sum of new values not the original values obtained after the multiplications.

    I think your intention is to show the whole number while keeping the original value intact so that when these are summed, you get the correct result. Right?

    If this is the case you may use custom formatting on formula cells with multiplication with #,###, so the whole numbers will be shown in the formula cells but you will get the sum of original values.

    To Custom Format the formula cells, select the formula cells, right click and select Format Cells, there on Number Tab, select Custom and in the box where you see General by default, paste the suggested format.

    Does this help?
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  2. #2
    Forum Contributor
    Join Date
    12-11-2014
    Location
    dubai
    MS-Off Ver
    2010
    Posts
    142

    Re: Round formula and percentage multiplication error

    hi sktneer

    but again that is just displaying as whole number, when you upload that in system, it will still be decimal point..

+ 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. Multiplication Formula Error
    By lucolem in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-28-2014, 08:11 AM
  2. Find the Percentage, Then Round Up
    By mknewnham in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-14-2014, 06:11 PM
  3. Need formula for figuring percentage off and then round to nearest dollar
    By Joanne P in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-30-2012, 05:11 PM
  4. Percentage & rounding with int and round
    By chambone2000 in forum Excel General
    Replies: 4
    Last Post: 02-18-2011, 12:58 PM
  5. round down a percentage
    By drgogo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-18-2008, 06:11 AM
  6. multiplication formula error
    By ZOHAR in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-21-2007, 02:10 PM
  7. How do I round down a tax percentage
    By Bill in forum Excel General
    Replies: 3
    Last Post: 11-25-2005, 03:00 AM

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