In this example, I’d like to multiply 214 500 by 100-10% (= 90%) but the cell containing 214 500 is spanning two rows.
I tried with F36, F36:F37 and F37 but none worked. Any ideas ?
100% - 10% = 90%
100 - 10% = 9990% = 99,9
100 - (10% of 100) = 90
Anyway: The content (or formula result) of a cell overlaying a merged range is referenced as if it isn’t merged. This uses the address of the topmost leftmost cell of the merged range.
All the other cells of the range, even if overlaid due to merging, still exist, can have content, and can be referenced. References to them use their addresses as if no merging took place.
Wrong alert : it wasn’t about the cell, it was about using the wrong locales ! (. instead of ,). Fixed !