| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
users must enter value = or than a certain value
How do make users enter a dollar amount that is equal to or greater than a
certain amount. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
users must enter value = or than a certain value
On Oct 31, 11:51*am, springtimetigger
wrote: How do make users enter a dollar amount that is equal to or greater than a certain amount. * Validation under the Data menu. Select "Decimal", "greater than or equal to", and your certain amount. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
users must enter value = or than a certain value
Hi,
Choose Data, Validation, and from the Allows list pick either Whole numbers or Decimals and then choose Greate than or equal to. -- Thanks, Shane Devenshire "springtimetigger" wrote: How do make users enter a dollar amount that is equal to or greater than a certain amount. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
users must enter value = or than a certain value
Thanks!
"ShaneDevenshire" wrote: Hi, Choose Data, Validation, and from the Allows list pick either Whole numbers or Decimals and then choose Greate than or equal to. -- Thanks, Shane Devenshire "springtimetigger" wrote: How do make users enter a dollar amount that is equal to or greater than a certain amount. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i force users to first enter data in one cell before anythi | Excel Discussion (Misc queries) | |||
| Protect cells from other users w/out me having to enter pw | Excel Discussion (Misc queries) | |||
| Forcing users to enter value based on criteria | Excel Discussion (Misc queries) | |||
| Shared Workbook Ability For Users To Enter New Records. | Excel Discussion (Misc queries) | |||
| Defining specific areas for users to enter data | Excel Discussion (Misc queries) | |||
Linear Mode
