Hi all,

I desperately need a formula using which I could differentiate two categories of countries..
So there are two categories of countries, reliable ones and non-reliable ones. All of them are in one column, let's say Column A
Reliable countries: Italy, USA, France, Spain, etc. Non-reliable countries China, Turkey, Egypt.

I need a formula using which I could get value equal to the value in column A when it is a reliable country and value "non-reliable" when the country is non-reliable

It would be great to get a result similar to this one:

| A | B |
---------------------------
1 | Italy | Italy |
---------------------------
2 | China | Non-reliable |
---------------------------
3 | USA | USA |
---------------------------
4 | France | France |
---------------------------
5 | Turkey | Non-reliable |
---------------------------
6 | Spain | Spain |
---------------------------
7 | Egypt | Non-reliable |
-----------------------------

Can anyone please advice me on this?


Thanks in advance