|
how to set the value of a cell from another cell
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 |
how to set the value of a cell from another cell
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" a écrit dans le message de news: ... 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 |
how to set the value of a cell from another cell
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 |
how to set the value of a cell from another cell
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 |
how to set the value of a cell from another cell
I mean the solution was irrelevant... It's like i'm trying to buy a car and you suggest to have a burger instead... :confused: -- naddad ------------------------------------------------------------------------ naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817 View this thread: http://www.excelforum.com/showthread...hreadid=552285 |
how to set the value of a cell from another cell
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... :confused: -- naddad ------------------------------------------------------------------------ naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817 View this thread: http://www.excelforum.com/showthread...hreadid=552285 |
| All times are GMT +1. The time now is 02:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com