Thread: Partial input
View Single Post
  #1   Report Post  
Brad
 
Posts: n/a
Default Partial input

When cell C12 = 1 , I would like the user to be able to input a value in C13
When cell C12 1, I want to control the input in C13

ie when c12 = 1 the use would enter values ranges 1 through 52
when c12 1 I would chose the appropriate number to use (again 1 through 52)

Can I have an "equation" in cell C13 to do this? I realize that the desired
result can be done using additional cells, but was wondering if it could be
done in one cell?