Thread: Partial input
View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default Partial input

How about an alternative?

You could use another cell (C14??) to get the value you want:

=if(c12=1,c13,yourformulahere)

Then just use c14 as the cell with the "real" value.



Brad wrote:

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?


--

Dave Peterson