=if(and("", formula needed

[srizki]

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 something like.

=IF(AND(G1=””,””,IF(LEFT(G1,1)=4, “BIL”, LEFT(G1,1)=7, “NON”), “”).

Of course the formula is wrong, don’t know how to fix it.

 

[Jonmo1]

Try

=IF(G1="","",IF(LEFT(G1,1)="4","BIL",IF(LEFT(G1,1)="7","NON","")))

 

[srizki]

Thank you Jonmo1.

 

[Jonmo1]

You're welcome.