Currency formula
 

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

Currency formula
 

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

Currency formula
 

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"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

Currency formula
 

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


--
__________________________________
HTH

Bob

"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

Currency formula
 

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

Currency formula
 

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

Currency formula
 

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


"Niek Otten" wrote:

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

Currency formula
 

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" wrote in message
...
no when i input the formula its shows others in all the cell
--
Nisha P


"Niek Otten" wrote:

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