Dear All,
I need to clear a value in a cell(what ever may be the value) based on a condition in another cell and set it to blank.
Ex: If cell A is blank and then i need make cell B also blank, if cell A has some value then i should not disturb B
I need to do this using formula.
I have tried the below, but no use,
IF(AA1="",REPLACE(Y1,1,10,""))
Any ideas gurus?
Bookmarks