Thread: when setting a cell to equal a blank cell it displays 0
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BWildeRed BWildeRed is offline
external usenet poster
  
Posts: 1
Default when setting a cell to equal a blank cell it displays 0
If I make cell A1=B1 the result in A1 is 0 (zero) if B1 is blank. Is it
possible to have a blank result in A1? I am trying to create a template where
I have some cells equate to others and I would like the cells to show blank
if there is no data in the target cells.
Reply With QuoteReply With Quote