Forum Discussion
multiplication formula not working
Something like 10.0397467%.
Detlef_LewinThank you for that, it seems like that is the issue. The 10.04 is being calculated from another formula in the sheet and I set the format to show 2 places. How do I get it to use the 10.04 and not the 10.039747?
Thanks
it seems like that is the issue. The 10.04 is being calculated from another formula in the sheet and I set the format to show 2 places. How do I get it to use the 10.04 and not the 10.039747?
Just a quick postscript to this thread. Your title is "multiplication formula not working," which, if true, would mean that Excel is miscalculating all kinds of things for its millions of users around the world. It would also mean that somehow you have discovered this major bug in the program that those millions rely on.
So as a gentle nudge: whenever you find yourself thinking that Excel (or a formula in Excel) is "not working", remind yourself that Excel (99.99999% probability) IS working as intended, and that the "not working" really applies to an assumption you're making--about the precision of the numbers in this case, but it could be about some other aspect of your data, how that data is arrayed, etc.
Are there ever real bugs in Excel? Yes, but rarely, and we (I say as a fellow user) shouldn't expect to find them this easily.
- Use ROUND() or any other rounding function.
- That worked, thanks for your help.
