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
|