Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
data over formula
Is it possible to work around having a cell or cells with a formula,
and being able to write directly to the cell without erasing the formula? i tried with =if and so on but can get it to work . any comments? Greetings |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
data over formula
Hi Angel.
No comment, because a cell can contain OR a string, OR a value, OR a formula; please ceck your help on line to verify. Eliano "Sangel" wrote: Is it possible to work around having a cell or cells with a formula, and being able to write directly to the cell without erasing the formula? i tried with =if and so on but can get it to work . any comments? Greetings |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
data over formula
When I want a formula (for a default value), an input from the user (an
override), I'll use 3 cells: For instance: A2 = formula (a locked cell on a protected sheet) B2 = shaded yellow for user input (an unlocked cell) C2 = formula (=if(b2="",a2,b2) (also locked) Then I use C2 in all the other formulas. Sangel wrote: Is it possible to work around having a cell or cells with a formula, and being able to write directly to the cell without erasing the formula? i tried with =if and so on but can get it to work . any comments? Greetings -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to sum data from a data range | Excel Discussion (Misc queries) | |||
Formula to capture historical data from data that changes daily | Excel Discussion (Misc queries) | |||
Formula to capture historical data from data that changes daily | Excel Worksheet Functions | |||
Any cell containing formula seen as data instead of formula | Excel Worksheet Functions | |||
DATA VALIDATION - for data which is the result of a formula | Excel Programming |