Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear Cell Without Removing Formula
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear Cell Without Removing Formula
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear Cell Without Removing Formula
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Clear Cell Without Removing Formula
you can't clear the result of a formula. You can only hide it (match the
text to the background, hide the row or column, etc.). Why would you want to do that? Maybe if you can answer that, we might be able to give you a viable workaround. For example if you don't want a cell to be included in a SUM formula, you can use SUBTOTAL which ignores cells that have been filtered out. "Scott" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Cannot enter formula in a cell after removing a circular formula | Excel Worksheet Functions | |||
Clear cell from formula? | Excel Discussion (Misc queries) |