cell help

F

Florida Richard

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?
 
D

Dave O

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.
 
G

Gord Dibben

Data>Validation>Whole Number

Minimum 2

Maximum 100000000000000000

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


Gord Dibben MS Excel MVP
 
Top