assigning a function to a cell remotely

J

jinx2311

Hi All,

I have a cell (say, A1) which receives input from user, a cell B1 which
should compute/display a value based on the input in A1. If I write a
condition or formula for this in B1, its gets over-written once I input
a value in A1 and correspondingly B1 takes the desired value. So I
cannot re-use the condition for another input in A1.

As suggested by someone previously I tried to link the function in B1
to a different cell C1, but I am not sure if I am doing it correctly.
If someone could take a look below and help me out, it would be great!

C1=IF(A1=1,B1=2,B1=4)

Can I do this?If yes, how? As of now, it gives me a true or false value
in C1 and nothing in B1, when I input value in A1.

Please help!Thanks in advance!
 
J

JE McGimpsey

Functions return values to their calling cells. They cannot change the
values in other cells.

It's not clear to me from your post what you're expecting to see.

B1: =IF(A1=1, 2, 4)

will display 4 in B1 unless A1=1, in which case it will display 2.

What are you trying to accomplish?
 
J

jinx2311

I am sorry, I left out a crucial part in my dilema....cell B1 is also
an input cell....it displays selected list based on input in A1. The
values 2 and 4 in arguements are just examples. I have drop down lists
in B1 which will get displayed only if it satisfies the condition wrt
value in A1.And user selects values from that particular list in B1. So
once that value is selected, if there is a formula in B1 to display the
lists, its getting over written when the user selects value in B1 from
the list.

Am I making any sense at all?

Once again sorry for the confusion!
 
N

Niek Otten

You did not answer one crucial question posed by JEmcGimpsey:

"What are you trying to accomplish?"

What is your real-world problem, not the problem with Excel cells?
IOW why should you need such a volatile construction; sure it can be done in
a more robust way?
 
Top