Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
currency
hi, i am trying to create an if statement with different currency. for example:
Col. A B C Value: EUR USD (can either be EUR, USD) (if "A2" is a Euro, then the value goes in "B2." If the Value is in US dollars, then value has to go in "C2." ) How do i write a statement to that can identify between currencies? Thank you, -- hmz nyc |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
currency
hmz you say:-
"the value" What do you mean by this and in which cell is it to be found? "hmz" wrote: hi, i am trying to create an if statement with different currency. for example: Col. A B C Value: EUR USD (can either be EUR, USD) (if "A2" is a Euro, then the value goes in "B2." If the Value is in US dollars, then value has to go in "C2." ) How do i write a statement to that can identify between currencies? Thank you, -- hmz nyc |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
currency
The value as in a number value....for example, instead of it being american
dollars, it is Euros. it would be in A1, A2, A3, etc. I need excel to recognize the difference between the currency because if it is usa, then I want the value to be placed in it. etc. -- hmz nyc "trip_to_tokyo" wrote: hmz you say:- "the value" What do you mean by this and in which cell is it to be found? "hmz" wrote: hi, i am trying to create an if statement with different currency. for example: Col. A B C Value: EUR USD (can either be EUR, USD) (if "A2" is a Euro, then the value goes in "B2." If the Value is in US dollars, then value has to go in "C2." ) How do i write a statement to that can identify between currencies? Thank you, -- hmz nyc |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
currency
OK so this is what you seem to be saying:-
IF cell A 2 is formatted with a EUR currency symbol in it take the number (for example 1.00) appearing in cell A 2 and place it into cell B 2 (so B 2 would end up with just 1.00 without the EUR symbol in it). OR if cell A 2 is formatted with a USD currency symbol in it take the number (for example 1.00) appearing in cell A 2 and place it into cell C 2 (so C 2 would end up with just 1.00 without the USD symbol in it). If that is what you are saying I dont know how to do that (sorry) but somebody else in this group probably does. "hmz" wrote: The value as in a number value....for example, instead of it being american dollars, it is Euros. it would be in A1, A2, A3, etc. I need excel to recognize the difference between the currency because if it is usa, then I want the value to be placed in it. etc. -- hmz nyc "trip_to_tokyo" wrote: hmz you say:- "the value" What do you mean by this and in which cell is it to be found? "hmz" wrote: hi, i am trying to create an if statement with different currency. for example: Col. A B C Value: EUR USD (can either be EUR, USD) (if "A2" is a Euro, then the value goes in "B2." If the Value is in US dollars, then value has to go in "C2." ) How do i write a statement to that can identify between currencies? Thank you, -- hmz nyc |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
currency
How do you intend to keep track of exchange rates?
Where would that factor be placed on your sheet? I think you would need VBA to recognize the format and make the appropriate conversion to EUR or USD. Gord Dibben MS Excel MVP On Thu, 14 Jan 2010 09:12:01 -0800, hmz wrote: The value as in a number value....for example, instead of it being american dollars, it is Euros. it would be in A1, A2, A3, etc. I need excel to recognize the difference between the currency because if it is usa, then I want the value to be placed in it. etc. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add new currency Symbol in Format/Cell/Currency | Excel Discussion (Misc queries) | |||
Currency without a $ | Excel Discussion (Misc queries) | |||
how do I sum currency values in a row containing currency and uni. | Excel Worksheet Functions | |||
Currency | Excel Discussion (Misc queries) | |||
Currency | Excel Discussion (Misc queries) |