Currency formula

[nishkrish]

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

 

[Fred Smith]

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

 

[Niek Otten]

=if(e2="INR","INDIA","OTHERS")

 

[Bob Phillips]

=if(e2="INR","INDIA","OTHERS")

 

[nishkrish]

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.

 

[Niek Otten]

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

 

[nishkrish]

no when i input the formula its shows others in all the cell

 

[Niek Otten]

There are probably spaces or other nonprinting characters in E2. Use the
TRIM() function or test for other characters. Use LEN() to determine the
number of characters and then test each of them

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

no when i input the formula its shows others in all the cell