users must enter value = or > than a certain value

S

springtimetigger

How do make users enter a dollar amount that is equal to or greater than a
certain amount.
 
S

Spiky

How do make users enter a dollar amount that is equal to or greater than a
certain amount.  
Click to expand...

Validation under the Data menu. Select "Decimal", "greater than or
equal to", and your certain amount.
 
S

ShaneDevenshire

Hi,

Choose Data, Validation, and from the Allows list pick either Whole numbers
or Decimals and then choose Greate than or equal to.
 
S

springtimetigger

Thanks!

ShaneDevenshire said:
Hi,

Choose Data, Validation, and from the Allows list pick either Whole numbers
or Decimals and then choose Greate than or equal to.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes or blank, depending if value equals or exceeds value found inVLookup table. 4
Sliding Commission Formula 2
looking for a function that will populate opening a worksheet or t 2
Subtracting two cell dates and highlight if over due by a certain amount of days 0
IF, THEN SYNTAX 5
How do I display text when a cell value is 0 for accounting? 0
If greater than 5 4
Yes or No Value if Dollar amount between two numbers 1

Top