Can Cell X modify Cell Y?

[Guest]

Example:

If cell A1 equals 1, then cell B1 should have the value 5, otherwise B1
should be 6.

A condition in cell A1 is changing the value of cell B1... is that possible?

 

[Myrna Larson]

Yes, of course. B1 contains this formula: =IF(A1=1,5,6)