In two of my spreadsheets, Excel is giving incorrect answers to very simple cell1*cell2 math calculations. I am running Microsoft excel 2007 on a Windows 7 machine. The cells that I am trying to multiply contain formulas that include the multiplication of other cells. These values are correct. When I ask excel to multiply them together though, it gives incorrect answers. The answers are very off, so it is not a rounding error. If I create new cells that are not formulas, just the raw numbers, and multiply those, excel gives me the correct answers.
Any thoughts?
Any thoughts?