Searching in columns

[stratis]

Hi,

I have the following problem:
I would like to construct a formula which will create the result in the column “Result from the formula”.

Way that I would like to make the formula works:
Looking to the column result if the result is YES or NO. Note that there is no other option.
The result in the column “Result from the formula” should be based in the data in columns “Account” and “State”.

Available Options:

• The result for all the accounts of a certain category is ‘NO” in column “State”: In this case the formula should bring “NO” in all the respective accounts (e.g. case of account 12.04)
• The result for an account with the less possible digits (5 including the “.”) is ‘YES” in column “State”: In this case the formula should bring “YES” in all the other accounts with the same beginning but more digits (e.g. case of account 12.06)
• All the accounts of one level (e.g. accounts 30.01.00.00.00 and 30.01.00.00.99) have the same state “YES”. In this case the accounts with smaller details (e.g. 30.01.00.00, 30.01.00 and 30.01) should be filled with “YES”.

<tbody>
</tbody>

Example:

Account	State	Result from the formula
12.04	NO	NO
12.04.00	NO	NO
12.04.00.00	NO	NO
12.04.00.00.00	NO	NO
12.04.00.00.07	NO	NO
12.06	YES	YES
12.06.00	NO	YES
12.06.00.00	NO	YES
12.06.00.00.04	NO	YES
12.06.00.00.05	NO	YES
50.00	NO	NO
50.00.00	NO	NO
50.00.00.00	NO	NO
50.00.00.00.00	YES	YES
50.00.00.00.91	NO	NO
30.01	NO	YES
30.01.00	NO	YES
30.01.00.00	NO	YES
30.01.00.00.00	YES	YES
30.01.00.00.99	YES	YES

<tbody>
</tbody>

Is this possible to happen?