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

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