Bring in remaining data from If Then statement

[skeen503979]

I'm trying to consolidate the names of some of our departments.  What formula can I use to perform an IF-THEN statement on some of our departments, but still bring in the remaining departments that I don't want to rename?

That may have been confusing.  Let me try to explain this way:

If I have a list of A, B, C, D and I want to rename C and D to call them E how can I create a column that still shows all the A's and B's and the newly renamed E's?  Below is my working formula to rename the departments I needed, but it is not displaying the other department names that I don't want to rename.

I hope that makes sense.

[danilang · Accepted solution]

Hi @skeen503979 

Instead of the Null() in your Else clause use [DEPT_DESC]. 

Dan

[bpatel]

hi @skeen503979 ,

hope this helps!

[skeen503979]

@danilang 

That worked for me.  Thanks so much for the help!