Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set default value for a cell
I would like a cell to start with a default value based on another cell, but
allow the user to override the value using a choice from a list in data validation. How do I set the original default value? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set default value for a cell
You put a formula in the cell. Something like
=if(a1="something",2,"") Regards Fred "CEM Matt" <CEM wrote in message ... I would like a cell to start with a default value based on another cell, but allow the user to override the value using a choice from a list in data validation. How do I set the original default value? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set default value for a cell
Thanks, Fred. I did end up entering an IF formula, then set up a data
validation list for the user to select from. The only problem, if the user selects an option, the formula is gone and the cell will no longer default, it must always be manually set. I haven't tried this. Is it possible to put a furmula in a data validation list, so the user can put the default back in, should he decide he wants the system to choose the correct response? Matthew "Fred Smith" wrote: You put a formula in the cell. Something like =if(a1="something",2,"") Regards Fred "CEM Matt" <CEM wrote in message ... I would like a cell to start with a default value based on another cell, but allow the user to override the value using a choice from a list in data validation. How do I set the original default value? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
set default value for a cell
I don't use data validation, so I can't help you with that. My suggestion is
to post your question in a separate thread. It will get much more attention than this one. You're right, it you enter something in your cell, you lose the formula. Possible solutions a 1. Use two cells. Enter data in one cell, the other is the formula, something like: =if(a1<"",a1,"default") 2. Use a macro Regards, Fred "CEM Matt" wrote in message ... Thanks, Fred. I did end up entering an IF formula, then set up a data validation list for the user to select from. The only problem, if the user selects an option, the formula is gone and the cell will no longer default, it must always be manually set. I haven't tried this. Is it possible to put a furmula in a data validation list, so the user can put the default back in, should he decide he wants the system to choose the correct response? Matthew "Fred Smith" wrote: You put a formula in the cell. Something like =if(a1="something",2,"") Regards Fred "CEM Matt" <CEM wrote in message ... I would like a cell to start with a default value based on another cell, but allow the user to override the value using a choice from a list in data validation. How do I set the original default value? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Apostrofe in cell by default | Excel Discussion (Misc queries) | |||
Default cell name and value | Excel Worksheet Functions | |||
set a default value for a cell ? | New Users to Excel | |||
how do you get rid of default 0 in a cell that has a formula set u | Excel Discussion (Misc queries) | |||
Default cell format | Excel Discussion (Misc queries) |