Cell Content via Secondary Formula

[Rob]

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

 

[JLatham]

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","")

 

[Ron Rosenfeld]

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