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