Assign value to another cell?

[dgarris]

Can you assign a value to another cell?

Example

Cell A1 content needs to set a value in Cell A2.

Cell A1 contains the formula: =If(condition, A2=1, A2=2)

I realize you can not put A2=1 in the value_if_true location but I'd like to cause cell A2 to get the value of 1 somehow when the condition is true.

[Paul]

Hi dg,

I think what you're asking is "based on a condition in cell A1, fill in a certain value in cell A2". Is that right?

If so, then put this formula in cell A2:

=IF(condition, 1, 2)

where condition could be just about anything. For example,

=IF(A1="Service", 1, 2)

Would put the number 1 in cell A2 if the word "Service" appeared in cell A1, and if not it would put the number 2.

[dgarris]

Paul,
I really want to know if there is a way to cause a value to be set in another cell from a different cell location.

[Paul]

Not through formulas there isn't. A formula "gets" a value from another cell, it cannot put a value into another cell.

Using VBA code you can type values in one set of cells and have other cells update based on those changes, though.

[dgarris]

Thanks Paul.