If data in Column B is Blank then Reference Column A and if data in Column A & B are blank then reference Column C.

[jgome21]

Hi Guys,

I am trying to create a formula where I have a set of Data in Columns A, B & C.
If the Cell in Column B is Blank then it references the adjacent cell in Column A in Column D.
If the Cell in Columns B and A are both Blank then if references the adjacent Cell in Column C in Column D.

What would you suggest using in the IF statements?

 

[translators]

Birth Certificate Translation

Birth Certificate Translation