I need a formula, that see in column G, if the corresponding cell in G is empty, it leaves empty, if the first digit is 4 then the formula should populate “BIL”, (no quotes), if the first digit is 7 then “NON”.
So there are three condition, if it is empty, leave empty, So the formula will be...