Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting a minimum currency value
Hello,
I have a locked worksheet distributed to users where they insert certain values. One of the fields is for currency and I want to code it so that it will NOT accept an amount of less than $100,000. I can't seem to find out how to do this. Any help would be appreciated. Thanks, George |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting a minimum currency value
Use Data Validation, under the Data menu item. Choose Decimal (or whole
number, whatever fits your needs), and then choose your parameters, such as, greater than or equal to. -- John C "George" wrote: Hello, I have a locked worksheet distributed to users where they insert certain values. One of the fields is for currency and I want to code it so that it will NOT accept an amount of less than $100,000. I can't seem to find out how to do this. Any help would be appreciated. Thanks, George |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting a minimum currency value
Thanks very much! That works perfectly.
"John C" wrote: Use Data Validation, under the Data menu item. Choose Decimal (or whole number, whatever fits your needs), and then choose your parameters, such as, greater than or equal to. -- John C "George" wrote: Hello, I have a locked worksheet distributed to users where they insert certain values. One of the fields is for currency and I want to code it so that it will NOT accept an amount of less than $100,000. I can't seem to find out how to do this. Any help would be appreciated. Thanks, George |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting a minimum currency value
Thanks for the feedback.
-- John C "George" wrote: Thanks very much! That works perfectly. "John C" wrote: Use Data Validation, under the Data menu item. Choose Decimal (or whole number, whatever fits your needs), and then choose your parameters, such as, greater than or equal to. -- John C "George" wrote: Hello, I have a locked worksheet distributed to users where they insert certain values. One of the fields is for currency and I want to code it so that it will NOT accept an amount of less than $100,000. I can't seem to find out how to do this. Any help would be appreciated. Thanks, George |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
minimum and the corresponding value | Excel Worksheet Functions | |||
How to lookup the minimum, 2nd minimum and 3rd minimum......... | Excel Worksheet Functions | |||
Minimum but One?? | Excel Worksheet Functions | |||
Minimum Value | Excel Worksheet Functions | |||
Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) |