A cells contains a math formula, meaning it contains
=234+3456-456
the value in that cell is displayed correctly (ie. 3234)
When I include this cell in a SUM range, its value is completely ignored as if it is not part of the range (or value = 0). If I manually input that cell value as 3234, then the SUM function is correct. The thing is I need the cell to show the calculation as separate numbers but use the final value in the SUM function. It works just like that in both Excel and Google Sheets, why not LO?
Any advice?