View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Formulas in Cells

Maybe you can adjust your formula so that the cell looks empty under certain
conditions:

=if(a1<10,"",yourformulahere)

(for example)



Sheryl wrote:

How do I clear the numbers in the cells but keep the formulas?


--

Dave Peterson