in B1 for example
=if(A1="yes","",Current_formula_in_B1)

--
Regards,
Tom Ogilvy


"tony wong" wrote in message
...
if the left cell is "yes", erase right cell.

How should i do with it in the simplest way?

formula, macro or script?

Thanks.