Cell Content via Secondary Formula
 

Hello... I was wondering if it were possible to have a formula that
evaluates the content of a cell and then change the values of another cell
based on the criteria?

Range A1 has the evaluation formula
Range B1 has the data to evaluate
Range Sheet2 A1 is changed per A1's Logic

Range A1 = IF(B1="Yes",Sheet2!A1="OK",Sheet2!A1="")


Thanks in Advance,
Rob

Cell Content via Secondary Formula
 

Don't worry about using B1 on the first sheet, instead put your IF function
into A1 on Sheet2, looking back at A1 on the other sheet. In A1 on Sheet2:
=IF(Sheet1!A1="YES","OK","")


"Rob" wrote:

Hello... I was wondering if it were possible to have a formula that
evaluates the content of a cell and then change the values of another cell
based on the criteria?

Range A1 has the evaluation formula
Range B1 has the data to evaluate
Range Sheet2 A1 is changed per A1's Logic

Range A1 = IF(B1="Yes",Sheet2!A1="OK",Sheet2!A1="")


Thanks in Advance,
Rob

Cell Content via Secondary Formula
 

On Tue, 7 Jul 2009 04:28:01 -0700, Rob wrote:

Hello... I was wondering if it were possible to have a formula that
evaluates the content of a cell and then change the values of another cell
based on the criteria?

Range A1 has the evaluation formula
Range B1 has the data to evaluate
Range Sheet2 A1 is changed per A1's Logic

Range A1 = IF(B1="Yes",Sheet2!A1="OK",Sheet2!A1="")


Thanks in Advance,
Rob

All that a formula can do is return a value. It cannot alter another cell.

So the way to do this would be to have a formula in Sheet2!A1 that looks at
Range A1 (or even at B1 directly).

If you cannot have a formula in Sheet2!A1, but must have only a value, then you
will need to use a VBA Sub.
--ron