Tags: based, cell, excel, formula, microsoft, msdn, software, value

How do I set a cell value based on a formula in another cell?

On Microsoft » Microsoft Excel

1,351 words with 1 Comments; publish: Thu, 22 May 2008 20:45:00 GMT; (30678.00, « »)

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

All Comments

Leave a comment...

  • 1 Comments
    • 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?action=getinfo&userid=21059

      View this thread: http://www.excelforum.com/showthread.php?threadid=486739

      #1; Thu, 22 May 2008 20:46:00 GMT