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
Bookmarks