You can't do that with a formula, the cell either has a value or a formula,
it cannot have both. Either use another column or use VBA.

--
__________________________________
HTH

Bob

"Ranjit kurian" wrote in message
...
Hi
i have a doubt on IF function, i have two columns Name and DEPT, if we
have
A in column Name then the Dept will be Apple, and if allready name is
filled
in DEPT column (example 'Bun')then the IF function should not change any
thing it should be as it is.

Example:

Name DEPT
A =IF(A2="A","APPLE",?)
A =IF(A3="A","APPLE",?)
B BUN