Calculating the value of a cell from another cell
Let's say that the user entered values into cell G3 and that these
took precedence over anything else. Then in C3 you could have the
formula:
=IF(G3<"",G3,IF(C21,1,""))
This way your formula in C3 is intact (and could be protected to
prevent it being over-written), but your user still has the ability to
manually specify another value to be used.
Hope this helps.
Pete
On Jul 29, 11:04*pm, wrote:
I am interesting in how I would go about creating a value for a cell
by referencing it from another cell. *I know this logic doesn't work
in Excel, but it makes sense to me...
(Function connected with cell C2) IF(C21,C3=1,C3="")
If this worked then the user could also manually override the value in
C3.
If I placed the function above into the Cell C3 I loose the ability
for the user to hand-enter values into C3 without corrupting the
function.
Is this possible?
Thank you to anyone who may respond!
Greg
|