View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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