I am trying to create a condition in a form i am creating that would allow a
user to enter a number in a cell to caluculate something. But I would like to
set it up that whatever value they enter into that cell is a minimum number
of 2. The idea is that i do not want them to have teh ability to enter 0 or 1
in this cell. i tried =min(2) which out the number 2 in the cell but when you
attept to enter another numerb in the cell it wipes the formula. Any ideas?

When you say "a form I'm creating" do you mean a particular layout in
your spreadsheet, or an actual programming object called a form? The
answer to this question will drive your solution: you can provide some
data validation code that will not allow a user to enter a number less
than 2, but we need to know where and how to apply that code.

Use Data Validation
--
Gary''s Student


"Florida Richard" wrote:

I am trying to create a condition in a form i am creating that would allow a
user to enter a number in a cell to caluculate something. But I would like to
set it up that whatever value they enter into that cell is a minimum number
of 2. The idea is that i do not want them to have teh ability to enter 0 or 1
in this cell. i tried =min(2) which out the number 2 in the cell but when you
attept to enter another numerb in the cell it wipes the formula. Any ideas?

It is the particular layout of an excell spreadsheet that i created

"Dave O" wrote:

When you say "a form I'm creating" do you mean a particular layout in
your spreadsheet, or an actual programming object called a form? The
answer to this question will drive your solution: you can provide some
data validation code that will not allow a user to enter a number less
than 2, but we need to know where and how to apply that code.

DataValidationWhole Number

Minimum 2

Maximum 100000000000000000

Type an input message and/or an error alert message.


Gord Dibben MS Excel MVP

On Wed, 23 Aug 2006 08:05:01 -0700, Florida Richard
wrote:

I am trying to create a condition in a form i am creating that would allow a
user to enter a number in a cell to caluculate something. But I would like to
set it up that whatever value they enter into that cell is a minimum number
of 2. The idea is that i do not want them to have teh ability to enter 0 or 1
in this cell. i tried =min(2) which out the number 2 in the cell but when you
attept to enter another numerb in the cell it wipes the formula. Any ideas?