Currency formula

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
 
F

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
 
N

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

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula for currency or Macro help. 0
How to change the currency Symbal 2
No Balance Owed Flag Help! 2
Summary of Unique item values 2
Sum Products with VLOOKUP 3
Formatting numeric fields 3
Currency format 8
Formula for Detecting Currency Format 1

Top