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

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" <(E-Mail Removed)> wrote in message
news9F46D94-C7B9-490E-BCF1-(E-Mail Removed)...
>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

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"nishkrish" <(E-Mail Removed)> wrote in message
news9F46D94-C7B9-490E-BCF1-(E-Mail Removed)...
>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

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


--
__________________________________
HTH

Bob

"nishkrish" <(E-Mail Removed)> wrote in message
news9F46D94-C7B9-490E-BCF1-(E-Mail Removed)...
>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

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" <(E-Mail Removed)> wrote in message
> news9F46D94-C7B9-490E-BCF1-(E-Mail Removed)...
> >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
>
>

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"nishkrish" <(E-Mail Removed)> wrote in message
news:85B4309A-2459-4F5B-8D29-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
>> news9F46D94-C7B9-490E-BCF1-(E-Mail Removed)...
>> >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
>>
>>

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" <(E-Mail Removed)> wrote in message
> news:85B4309A-2459-4F5B-8D29-(E-Mail Removed)...
> >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" <(E-Mail Removed)> wrote in message
> >> news9F46D94-C7B9-490E-BCF1-(E-Mail Removed)...
> >> >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
> >>
> >>
>
>

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" <(E-Mail Removed)> wrote in message
news53CEEA4-1C6A-4993-9A77-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:85B4309A-2459-4F5B-8D29-(E-Mail Removed)...
>> >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" <(E-Mail Removed)> wrote in message
>> >> news9F46D94-C7B9-490E-BCF1-(E-Mail Removed)...
>> >> >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
>> >>
>> >>
>>
>>