View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andmor Andmor is offline
external usenet poster
 
Posts: 25
Default no data to return blank

I currently have this formula =IF(C80,C8-$G$3,"") in a series of cells which
is fine when there is information but I get a # value error when there is
nothing in the cells it looks to. Is there a way to have it leave the cell
blank if there is no data in the cells it looks to?
--
A.