Thread: Why does a formula take up 2 cells?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mark246 Mark246 is offline
external usenet poster
  
Posts: 19
Default Why does a formula take up 2 cells?
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
Reply With QuoteReply With Quote