| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multi-functional cells in Excell 2003
can a cell be multi-functional, IE accept user input data or formula
generated data without loosing the formula in the cell? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multi-functional cells in Excell 2003
No.
When I want to allow the user to supersede the formula's result, I use 3 cells. The formula cell (evaluates to the default value) the override cell (for manual input) the cell that's used. For instance: I'd put the formula in A1, the override value in B1 and use this in C1: =if(c1<a1,c1,a1) Lock columns A and C and protect the worksheet. Then I could use column C in any subsequent formulas. Evar RN wrote: can a cell be multi-functional, IE accept user input data or formula generated data without loosing the formula in the cell? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2003 functions no longer functional in 2007 | Excel Worksheet Functions | |||
| auto locking of excell workbook (excell 2003) | Excel Discussion (Misc queries) | |||
| Excel 2003 Multi Worksheet Sumproduct? | Excel Worksheet Functions | |||
| Multi Worksheet Sumproduct Excel 2003 | Excel Discussion (Misc queries) | |||
| Excell 2003 format cells | Excel Discussion (Misc queries) | |||
Linear Mode
