Thread: cell help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Florida Richard Florida Richard is offline
external usenet poster
 
Posts: 14
Default 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?