Currency Conversions with If Statements?

**swieduwi** · 10-01-2007, 11:39 AM

I am trying to figure out how to sum a row or column and to check weather a cell contains a Dollar "$" amount or Euro "€" Ect.
When I Calculate I need to convert everything to US dollar amount
in the expense report, I have the exchange rate.

I think I need a if cell a2 = "€" a2*"1.423" else if cell a2 = "&" a2*"0"
else if cell a2 = "£" a2*1.003"

Does this make sense?

**WinteE** · 10-01-2007, 12:35 PM

You better make a list of currencies and get the right one with VLOOKUP.

Erik

**swieduwi** · 10-03-2007, 12:33 PM

I am posting an example since I cant explain what I need

**WinteE** · 10-03-2007, 12:46 PM

You mean something like in the attached file ?

**swieduwi** · 10-03-2007, 12:59 PM

Yes, could you elaborate on how this is done.

And what if I want to include field 1 and field 2 in the same cell?
so it looks like | EUR EURO | 1.43232 |

**WinteE** · 10-04-2007, 02:09 AM

On my site you'll find a sample of how to create a listbox. To get the right currency based on the listbox selection I've used the VLOOKUP() function.
This function is explained in the Excel-help files.

To include the short currency description into the same field as the currency
you've got to do the next :

To let the VLOOKUP() work properly :

- Switch the first two columns of your currency table LONG DESC, SHORT DESC, CUR (now you can get the SHORT DESC with VLOOKUP() too
- Use CONCATENATE() to join the two VLOOKUP()'s together in one cell.

Succes,

Erik

**swieduwi** · 10-04-2007, 10:31 AM

Originally Posted by WinteE

On my site you'll find a sample of how to create a listbox. To get the right currency based on the listbox selection I've used the VLOOKUP() function.
This function is explained in the Excel-help files.

To include the short currency description into the same field as the currency
you've got to do the next :

To let the VLOOKUP() work properly :

- Switch the first two columns of your currency table LONG DESC, SHORT DESC, CUR (now you can get the SHORT DESC with VLOOKUP() too
- Use CONCATENATE() to join the two VLOOKUP()'s together in one cell.

Succes,

Erik

Thanks for your Help, Your Web Site is Very informative. Thanks