I’m sure I’ve done this same type of calculation in other spreadsheets, but, for some reason, the Calc output is mathematically incorrect. So I’m at a loss.
Anyway, here’s my situation:
I have a single cell that is to display the sum of two other cells divided by 2. Specifically…
C2 = 1.7 … C3 = 2.2 … C2+C3 = 3.9 … 3.9 / 2 = 1.95.
Here’s the syntax: (D3=)C2+C3/2. The calculated output in D3, however, is 2.8, not 1.95 (well, actually 2, due to the cell setting). Clearly this is not correct. (Parentheses not actually part of the calculation; added to show that I assigned that calculation to cell D3.)
I must just be missing something, but I cannot see where.
I’d be grateful for suggestions as to where to start looking for my error.