Then it is definitely the answer you have been given several times now

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"nishkrish" wrote in message
...
I guess there is something wrong in what i am trying to do actually the e2
column has currency and i want to check if the currency is EUR or $ it
should
show others or else INDIA.
--
Nisha P


"Fred Smith" wrote:

With your formula, Excel is looking for the range INR. Do you have such a
named range? Or did you mean:
=if(e2="INR","INDIA","OTHERS")

Regards,
Fred

"nishkrish" wrote in message
...
I have a currency column when i put formula it shows error #Name

formula i have is =if(e2=INR,"INDIA","OTHERS")

sir can you please help me
--
Nisha P