Why does a formula take up 2 cells?

M

Mark246

When I put this formula into cell N2, why does it occupy BOTH cells N2
and N3?

=IF(ISNUMBER(SEARCH(",",L2)),M2,L2)

Thanks

Mark246
 
M

Max

Did you read my further responses to you in your earlier thread?
Btw, if you do copy formulas direct from postings,
always try pasting directly into the *formula bar*
(this avoids any ambiguity which may arise)
 
D

David McRitchie

Hi Mark,
If the contents of a cell don't fit into the cell and it is not wrapped
then it will be extended for viewing into the next cell on the row if that next
cell is empty (no content, no formula). If you select the adjacent
cell and look at formula bar, you would see that there is nothing
there. If you actually see the formula in the cell then you are in
formula view or have a bad formula that is seen only as text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help Writing a SUM Formula 5
Update total based on two columns 1
Automatically change ranges when copying formula 7
ISNUMBER 2
Bold items within text string 7
SUMPRODUCT formula help 2
Summing cells based on mulitiple criteria over mulitple columns 1
Sumproduct where cell values are the same in a sorted column 1

Top