| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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...  -- naddad ------------------------------------------------------------------------ naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817 View this thread: http://www.excelforum.com/showthread...hreadid=552285 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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... -- naddad ------------------------------------------------------------------------ naddad's Profile: http://www.excelforum.com/member.php...o&userid=29817 View this thread: http://www.excelforum.com/showthread...hreadid=552285 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to set the value of a cell from another cell
Your question was completely dumb.
No other comments. -- AP "naddad" a écrit dans le message de news: ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
| Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
| Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
| How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
| data validation to restrict input in cell based on value of cell above that cell | Excel Programming | |||
![naddad[_7_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
