Thread: displaying an empty cell
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Eduardo Eduardo is offline
external usenet poster
  
Posts: 2,276
Default displaying an empty cell

Hi,
=if(Sheet1!C6="","",Sheet1!C6)

"Lynn" wrote:

I used to reference cells in our worksheets (e.g. =Sheet1!C6). if
Sheet1!C6 is empty i will get a 0 in my cell. How can i get a blank
cell if Sheet1!C6 is an empty cell?

thanks

Reply With QuoteReply With Quote