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


On Tue, 8 Feb 2005 12:03:02 -0800, "alMandragor"
wrote:

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?