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