+ Reply to Thread
Results 1 to 4 of 4

Formula answer not calculating correctly when two formulas are multiplied by ea other

  1. #1
    Registered User
    Join Date
    01-13-2010
    Location
    Bridgeport, NE
    MS-Off Ver
    Excel 2003
    Posts
    1

    Formula answer not calculating correctly when two formulas are multiplied by ea other

    I have two cells that I am multiplying. Each of the two cells contain formula answers. When I take the one cell and multiply it by the other cell I am not receiving the correct result. I think it must have something to do with the way my cell formatting is. Here is the scenario:

    When I try to multiple the "answer" from B13 which is 46.88 by the "answer" from N13 which is $.11 I receive the answer $5.04. The correct answer is $5.16 when rounded to two decimal places.


    Cell B13 contains the formula: D13/0.32 The answer that is shown in Cell B13 is 46.88 and the cell is formated as a number with 2 decimal places

    D13 has the number 15.00 entered into it and the cell is formated as a number with 2 decimal places.

    N13 contains the formula: O13/2000 The answer that is shown in Cell N13 is $.11 and the cell is formated as currency with 2 decimal places

    O13 contains the dollar amount $215.00 and the cell is formated as currency with 2 decimal places

    Cell L13 contains the formula: B13*N13 (46.88 x $.11) the answer that is shown in Cell L13 is $5.04 and the cell is formated as currency with 2 decimal places. The correct answer should show $5.16.

    My guess is that somehow the two formula answers when multiplied together are somehow adjusting the decimal places so that I do not receive the correct dollar value of $5.16.

    When I enter the values of 46.88 and $.11 in two blank cells and then multiply them in a third blank cell elsewhere on the spreadsheet I receive the correct answer of $5.16. That is why I think it has something to do with the formulas being multiplied by each other.

    Any help would be greatly appreciated.

    MOD: thread moved to Worksheet Functions Forum

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Formula answer not calculating correctly when two formulas are multiplied by ea o

    Please post a workbook that illustrates.
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: Formula answer not calculating correctly when two formulas are multiplied by ea o

    Hi dhughes

    have you tried the roundup() fuction
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  4. #4
    Forum Expert darkyam's Avatar
    Join Date
    03-05-2008
    Location
    Houston, TX
    MS-Off Ver
    2013
    Posts
    2,191

    Re: Formula answer not calculating correctly when two formulas are multiplied by ea o

    I would suggest the Round function instead and use that on cells B13 and N13. =ROUND(D13/32,2), for example. Right now, the answers to your first two calculations are 46.875 and .1075, which really do multiply out to just less than 5.04.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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