Forum Discussion
Formulas not calculating
I'm trying to do a simple multiplication calculation in a spreadsheet.
The number in B26 is an Average of cells above it equalling 698
I'm trying to multiply B26 * B36 (just a number in cell equalling 785).
The math should equal 547,930, but instead it equals 548,297. I can't figure out why or how to fix this.
1 Reply
Make sure that column B is wide enough, and format cell B26 as General, or as number with at least 4 decimal places.
I suspect that you'll find that the value of B26 is not exactly 698, but something like 698.4675
The .4675 (or whatever it is on your computer) causes the difference.
