Assigning values to other cells from one cells formula
 

From one cells formula I would like to assign values to another
cell.
So if within Cell A1 I have a condition that is true I would like to
assign either a number or string to cell A2.

Thanks,




Rob

Assigning values to other cells from one cells formula
 

Formulas return values to the cell that they are in. The do not modify other
cells nor do they change formatting (conditional formatting is based on the
result of a formula, and is not the return value of a formula).

Your only hope is to place a formula in the other cell that links back to
the original cell. If that is not an option then you need to consider using
macros which can react to a cell changing value and update another cell
accordingly.
--
HTH...

Jim Thomlinson


" wrote:

From one cells formula I would like to assign values to another
cell.
So if within Cell A1 I have a condition that is true I would like to
assign either a number or string to cell A2.

Thanks,




Rob