Nested IF A is blank then use B, if B is also blank then type "X"...

[kyleno]

I did find a thread that came close to my solution... but not quite :-\

I have two columns K and L. If L is blank use the value of K. That worked out just fine with:

=IF(L40="", K40,L40)

My question is how to add an additional condition of: IF K40 is also blank THEN type "Unassigned".

It seems like it would be a simple solution.

Please and thank you!

 

[JoeMo]

=IF(AND(L40="",K40=""),"Unassigned",If(L40="", K40,L40))

 

[kyleno]

Thank you so much for your expediency JoeMo!

 

[JoeMo]

Thank you so much for your expediency JoeMo!

You are welcome - thanks for the reply.

 

[kyleno]

BTW it works perfectly!

 

[jtakw]

Hi,

A little shorter:

=IF(L40="",IF(K40="","Unassigned",K40),L40)