Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
All I need is the product of two cells in a third cell. I entered an
equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
#2
|
|||
|
|||
Answer: Simple multiplication of 2 cells = wrong product
Hi Crispycritter,
I'm sorry to hear that you're having trouble with your Excel calculations. It's possible that there may be a formatting issue causing the incorrect product to be displayed. Here are a few steps you can try to troubleshoot the problem:
I hope these steps help you resolve the issue with your Excel calculations. Let me know if you have any other questions or if there's anything else I can help you with.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
Can you give an example of the numbers in B29 and D29?
"chrisp" wrote: All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
I'll bet that either or both of those 2 cells contain formulas where the
formatting may only display 2 decimals, but the actual cell value is more then what's being displayed. When dealing in currency, it's always best to ROUND() your returns, *don't* just format them. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "chrisp" wrote in message ... All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
Yes, the value of B29 is 0.55 and D29 is $32.33 the result is a value in E29
of $17.68 -- Crispycritter "Ed Cones" wrote: Can you give an example of the numbers in B29 and D29? "chrisp" wrote: All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
Can I get in on that bet? ;o)
..55*32.33 returns 17.7815 in my Excel 2003. "Ragdyer" wrote: I'll bet that either or both of those 2 cells contain formulas where the formatting may only display 2 decimals, but the actual cell value is more then what's being displayed. When dealing in currency, it's always best to ROUND() your returns, *don't* just format them. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "chrisp" wrote in message ... All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
Double checked and both values are manually entered and formatted for only
two places after the decimal. Could it truely result in $0.10 difference? -- Crispycritter "Ragdyer" wrote: I'll bet that either or both of those 2 cells contain formulas where the formatting may only display 2 decimals, but the actual cell value is more then what's being displayed. When dealing in currency, it's always best to ROUND() your returns, *don't* just format them. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "chrisp" wrote in message ... All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
If D29 is exactly 32.33, then you'd get a product of 17.68 if B29 is
0.546860501082586, but if you've formatted the cell to display as 2 decimal places it would look like 0.55. If you get unexpected results it's always worth displaying more decimal places. -- David Biddulph "chrisp" wrote in message ... Yes, the value of B29 is 0.55 and D29 is $32.33 the result is a value in E29 of $17.68 "Ed Cones" wrote: Can you give an example of the numbers in B29 and D29? "chrisp" wrote: All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
What do they look like if you format them with 4 decimal places? Or try
another cell with D29*100 and B29*100. "chrisp" wrote: Double checked and both values are manually entered and formatted for only two places after the decimal. Could it truely result in $0.10 difference? -- Crispycritter "Ragdyer" wrote: I'll bet that either or both of those 2 cells contain formulas where the formatting may only display 2 decimals, but the actual cell value is more then what's being displayed. When dealing in currency, it's always best to ROUND() your returns, *don't* just format them. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "chrisp" wrote in message ... All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
Simple multiplication of 2 cells = wrong product
Problem solved. Thanks for all your help!
-- Crispycritter "Ed Cones" wrote: What do they look like if you format them with 4 decimal places? Or try another cell with D29*100 and B29*100. "chrisp" wrote: Double checked and both values are manually entered and formatted for only two places after the decimal. Could it truely result in $0.10 difference? -- Crispycritter "Ragdyer" wrote: I'll bet that either or both of those 2 cells contain formulas where the formatting may only display 2 decimals, but the actual cell value is more then what's being displayed. When dealing in currency, it's always best to ROUND() your returns, *don't* just format them. -- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "chrisp" wrote in message ... All I need is the product of two cells in a third cell. I entered an equation =B29*D29 in the third cell but the product is wrong. Checked it with calculator and another application. One of the two cells being multiplied is formatted for currency, but other instances of the same calculations are correct. Is there a glitch in excel 2003? -- Crispycritter |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple SUMIF formula gone wrong! | Excel Worksheet Functions | |||
How do I multiply a cell by the product of two other cells? | Excel Discussion (Misc queries) | |||
Excel vs. calculator multiplication product discrepancy... | Excel Worksheet Functions | |||
Need a 1 Column multiplication formula for 2600 cells. How? | Excel Worksheet Functions | |||
Matrix multiplication with empty cells | Excel Worksheet Functions |