cell help
 

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?

cell help
 

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.

cell help
 

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?

cell help
 

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.

cell help
 

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?