View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Scott
 
Posts: n/a
Default Clear Cell Without Removing Formula

Is there a way to preven Excel from removing a formula in a cell when just
clearing what is being displayed?

For example:
I have =IF(ISERROR(SUM(AG3+$AL$3-AH3)),"",SUM(AG3+$AL$3-AH3)) in a cell. The
users need to be able to clear the result without deleting the formula. Can
this be done? Thanks in Advance

(We're running Office 2003)

Thanks