Setting a minimum currency value

[George]

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

 

[John C]

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.

 

[George]

Thanks very much! That works perfectly.

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]

Thanks for the feedback.
--
John C

Thanks very much! That works perfectly.