You have to clear out the cells that are part of the formula that returns
the value of 15
F5, special and constants

--

Regards,

Peo Sjoblom


"Scott" wrote in message
...
Thanks for the reply, but that's not what I'm looking for.

What I mean is this:

If I have IF(ISERROR(SUM(AG3+$AL$3-AH3)),"",SUM(AG3+$AL$3-AH3)) in a cell
and that cell returns a value of 15 (for example), I want to be able to
erase
the value of 15 while leaving the formula in tact. If I go to the cell
and
click deltete, the formula and the value are gone. I just want to remove
the
value (15)

Thanks.

"Gary''s Student" wrote:

To clear the display of a formula without removing the formula:

Set the color of the font the same as the color of the cell background.
--
Gary's Student


"Scott" wrote:

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