Setting a minimum currency value

  • Thread starter Thread starter George
  • Start date Start date
G

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
 
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.
 
Thanks very much! That works perfectly.

John C said:
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.
Click to expand...
 
Back
Top