I get zero on a calculation that clearly is not zero. 0.8*e28 + 0.2 *e33 should be greater than 0.0
what do I do wrong?
the number 4.5 in Column E is actually the Value from E2 because the Range E2:E28 is merged.
The same with 5.0 from E29 but not E33!
If you unmerge E2:E33 you will see the Values from the »hidden« Cells in Column E
3 Likes
Could you upload the file containing the “mysterious” calculation? 
Just in case, check if automatic formula calculations are enabled (Menu / Data / Calculate, check AutoCalculate).
Try to change the vertical position property of the values in the merged cells. You will see thet the visual position of the cell content is not equals to the coordinates (row number) of the merged cell.
That indeed is the case. Thanks!
Changing the formula to 0.8Ă—E02 +0.2Ă—E29 solved the issue.
Rather counter intuitive though. Is there a way to format this in such a way to prevent this from happening? Is there a way to file a feature request to have (in this case) E29 through E33 have the same value? Or was there already one which got rejected?
unmerging the cells is not helpful for the users of the sheet