View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nicole L. Nicole L. is offline
external usenet poster
 
Posts: 4
Default If null, make cell blank

In a cell in a wksheet, it has a formula that pulls the value/words from
another worksheet cell. If the cell it's referencing is blank, Excel gives me
a "O" in the destination cell.

How do I make it give a blank if the referenced cell is empty?

Help!