I am trying to add a custom column in power query. if the column (A) has 6 digit number, I would like to contain the values from the B column, otherwise should contain values from the C column.

in another word:

New Custom Column = IF( A contains 6 digit, B, C)

How to get around this ? many thanks in advance.