I note that this entry is also asked and answered in Programming.
dingy101 Wrote:
How do I set a cell value based on a formula in another cell?
=IF(D4="P.B.A.",G8,0) ,This works to set the value in the cell the
formula
is in, say cell A1.
I would like to have this formula reside in cell A1 but set the value
in
cell A2 to (G8,0).
Also it would be helpful if I could lock cell A2 based on a False
condition
from this formula in cell A1.
Thanks
Gary
--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile:
http://www.excelforum.com/member.php...o&userid=21059
View this thread:
http://www.excelforum.com/showthread...hreadid=486739