View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardus Petus
 
Posts: n/a
Default problem with blank cell

In C1, enter:
=IF(B1="","",Your_formula)

HTH
--
AP

"chiuinggum" a écrit dans le message
de ...
I am facing problems with cell that has not been fill. In cell C1 there is

a
formula that reference to B1. But before B1 is fill, C1 will displayed.