Ask Your Question
0

How to address a cell that spans multiple lines ?

asked 2017-07-03 19:19:42 +0100

ychaouche gravatar image

image description

In this example, I'd like to multiply 214 500 by 100-10% (= 90%) but the cell containing 214 500 is spanning two rows.

image description

I tried with F36, F36:F37 and F37 but none worked. Any ideas ?

edit retag flag offensive close merge delete

Comments

100% - 10% = 90%
100 - 10% = 9990% = 99,9
100 - (10% of 100) = 90

Lupp gravatar imageLupp ( 2017-07-03 21:21:56 +0100 )edit

2 Answers

Sort by » oldest newest most voted
0

answered 2017-07-03 19:24:19 +0100

ychaouche gravatar image

Wrong alert : it wasn't about the cell, it was about using the wrong locales ! (. instead of ,). Fixed !

edit flag offensive delete link more
1

answered 2017-07-03 21:29:26 +0100

Lupp gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-03 19:19:42 +0100

Seen: 91 times

Last updated: Jul 03 '17