V
--Viewpoint
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'!C2>0,'General Info'!C2,"")
All linked cells contain text, not numbers, so I'm questioning the >0. Any
better alternatives?
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'!C2>0,'General Info'!C2,"")
All linked cells contain text, not numbers, so I'm questioning the >0. Any
better alternatives?