View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KL KL is offline
external usenet poster
 
Posts: 201
Default what does "" signify in an Excel formula

"clueless" wrote in message
...
Can anyone help?


It means: text string of zero-length. In the formulae it is typically used
to emulate empty cells (although it is not quite the same) , e.g.
=IF(A10,A1,""), or to convert a value to text, e.g. =A1&""

--
KL
[MVP - Microsoft Excel]
RU: http://www.mvps.ru/Program/Default.aspx
ES: http://mvp.support.microsoft.com/?LN=es-es
EN: http://mvp.support.microsoft.com/?LN=en-us
Profile: http://mvp.support.microsoft.com/profile/Kirill