View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
--Viewpoint --Viewpoint is offline
external usenet poster
 
Posts: 21
Default Link cells with text not numbers

I'm working with a worksheet of cells with general information (text) that I
linked to various cells on worksheets within a workbook. I created the
formula below and it works but I'm not sure it is the most accurate way to
write the formula.

=IF('General Info'!C20,'General Info'!C2,"")

All linked cells contain text, not numbers, so I'm questioning the 0. Any
better alternatives?