| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup formula for currency | New Users to Excel | |||
| Currency Formula | Excel Discussion (Misc queries) | |||
| Currency Conversion Formula | Excel Worksheet Functions | |||
| DIFFERENT CURRENCY FORMATS IN FORMULA | Excel Worksheet Functions | |||
| Currency Conversion formula | New Users to Excel | |||
Hybrid Mode
