+ Reply to Thread
Results 1 to 5 of 5

Excel multiplication

  1. #1
    Registered User
    Join Date
    11-24-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2

    Excel multiplication

    Hello Everyone!

    I'm having trouble with a basic excel calculation.

    D E F G H
    500.0 46.4 16 11 500.0

    Column D & E are figures I'm manually entering.
    F has the sum E/2.9
    G has the sum =(D1/E1) (no decimal places)
    H has the sum =(E1*G1) (1 decimal place)

    As you can see the calculation is H is incorrect, any ideas? I feel it is something to do with multiplying the formula in G. If I manually put a figure in G the calculation in H will be correct.

    Any thoughts?

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,511

    Re: Excel multiplication

    Even if you display the results of those calculations as integers, the underlying values are still fractional. You need to change the formulae as follows:

    F1: =ROUND(E1/2.9,0)

    G1: =ROUND(D1/E1,0)

    H1: =ROUND(E1*G1,1)

    Hope this helps.

    Pete

  3. #3
    Forum Expert
    Join Date
    05-05-2015
    Location
    Waterlooville,England
    MS-Off Ver
    Office 2010
    Posts
    22,632

    Re: Excel multiplication

    If by G you mean it is integer, then yes it is wrong but i suspect you have G formatted to show 0 decimal places so it "appears" to be 11 whereas it is actually 10.7759 ( to 4 decimal places).

    If really want G to be 11 then use =ROUND(D1/E1)

  4. #4
    Registered User
    Join Date
    11-24-2016
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2

    Re: Excel multiplication

    Perfect thank you!

  5. #5
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    22,511

    Re: Excel multiplication

    If that takes care of your original question, please select Thread Tools from the menu above your first post and mark this thread as SOLVED.

    Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).

    Pete

+ 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. How to do Reverse Multiplication In Excel?
    By AxleHead in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-08-2015, 12:51 PM
  2. multiplication and division Excel magic?!
    By SlaveII in forum Excel General
    Replies: 1
    Last Post: 02-08-2015, 07:19 AM
  3. [SOLVED] Multiplication Bug - Excel (Office) 2010
    By mgs in forum Excel General
    Replies: 5
    Last Post: 05-05-2014, 03:09 AM
  4. Getting Excel multiplication to ignore minus numbers
    By KeiranMac in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 02-23-2013, 08:36 PM
  5. Excel Multiplication Miscalculation
    By yawnzzzz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-02-2011, 05:11 PM
  6. multiplication formula in excel
    By v.muruganandam in forum Excel General
    Replies: 2
    Last Post: 07-25-2009, 01:30 AM
  7. [SOLVED] Matrix Multiplication:Excel SOMETIMES
    By Matrix Bill in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-06-2005, 02: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