ExcelBanter - Can Cell X modify Cell Y?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Can Cell X modify Cell Y? (https://www.excelbanter.com/excel-discussion-misc-queries/12137-can-cell-x-modify-cell-y.html)

alMandragor

Can Cell X modify Cell Y?

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)

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?

All times are GMT +1. The time now is 01:01 PM.