how to set the value of a cell from another cell

[naddad]

Hi,

I want to write a formula in cell A1 that sets the value of cell A2 to "Test".
How do I do that?

Thanks,

[Ardus Petus]

There is no way a formula entered in one cell can alter the contents of
another cell.

You may enter following formula =in A2:
=IF(A1=1;"test";"something else")

HTH
--
AP


"naddad" <naddad.29g97n_1150385103.4313@excelforum-nospam.com> a écrit dans
le message de news: naddad.29g97n_1150385103.4313@excelforum-nospam.com...
>
> Hi,
>
> I want to write a formula in cell A1 that sets the value of cell A2 to
> "Test".
> How do I do that?
>
> Thanks,
>
>
> --
> naddad
> ------------------------------------------------------------------------
> naddad's Profile:
> http://www.excelforum.com/member.php...o&userid=29817
> View this thread: http://www.excelforum.com/showthread...hreadid=552285
>

[naddad]

Your answer is completely irrelevant...
Maybe if I lay down my problem in its entirety it would help:

I want to make different scenarios based on the input I give to my worksheet. The Scenario tool helps but the problem is I need to make 20 scenarios and draw up a chart that plots the output (a percentage in my case) for each scenario.
In other words, I have an input X that i plug into my worksheet and I get an output Y. I want to compute the output for 20 different values of X.

Thanks,

[Die_Another_Day]

His answer is not irrelevant. You cannot (without code) change the
value of one cell from within another cell, this is a fairly well
recognized situation. The best you can do is you set A2's value to be
contingent upon A1's value as Ardus has politely tried to show. You
could also have a little respect for people who try to help you for
free.

HTH

Die_Another_Day

naddad wrote:
> Your answer is completely irrelevant.
>
>
> --
> naddad
> ------------------------------------------------------------------------
> naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817
> View this thread: http://www.excelforum.com/showthread...hreadid=552285

[naddad]

I mean the solution was irrelevant... It's like i'm trying to buy a car and you suggest to have a burger instead...

[Die_Another_Day]

Can you please provide further explanation of what you are trying to
do? Why do you need to set the value of A2? Why can't A2 =if(A1 =
"Whatever you want","Test","False")? Why does this not fix your issue?

Die_Another_Day

naddad wrote:
> I mean the solution was irrelevant... It's like i'm trying to buy a car
> and you suggest to have a burger instead...
>
>
> --
> naddad
> ------------------------------------------------------------------------
> naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817
> View this thread: http://www.excelforum.com/showthread...hreadid=552285

[Ardus Petus]

Your question was completely dumb.

No other comments.

--
AP

"naddad" <naddad.29g9wn_1150386003.0321@excelforum-nospam.com> a écrit dans
le message de news: naddad.29g9wn_1150386003.0321@excelforum-nospam.com...
>
> Your answer is completely irrelevant.
>
>
> --
> naddad
> ------------------------------------------------------------------------
> naddad's Profile:
> http://www.excelforum.com/member.php...o&userid=29817
> View this thread: http://www.excelforum.com/showthread...hreadid=552285
>