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 equall...
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.