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