Thread: 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

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.