Currency formula

  • Thread starter Thread starter nishkrish
  • Start date Start date
N

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

nishkrish said:
no when i input the formula its shows others in all the cell
Click to expand...
 
Back
Top