I'm new to this. I need to drop a value into a cell where there is nothing.
The 'target' cell should not have a formula because some days I would need
to place a one time value there , doing so would wipe out the formula.

Example:

A1 B1 C1
BOB JOE =IF(A1="bob",A2=B1)

A2
(BLANK)


I need the blank cell (A2) to take the value of B1 if C1 is true.
Maybe I have the syntax wrong, maybe it's not possible. Let me know.

Thanks