Exchange Value

[Maartenjanvdwielen]

Hi all,

I hope you'll be able to understand what kind of problem im facing.

I'm trying to create a database that is basically a list of prices in different currencies.

in order to make a comparison between different quotes we receive i would like to see the total price instant and without making the calculations myself.

I made a database with the following.

Currency - Price - Price in Euro.

So now iam looking to make a calculation between those values.

example: incase i enter USD in currency it automatically calculate the exchange rate with price to get "price in euro".

this exchange rates i would like to enter manual in a different sheet........

basically iam looking for a way to give tekst a number value.....

i really hope you understand my problems. i think this is the best i can do in english..... :

[comment]

basically iam looking for a way to give tekst a number value.

Not exactly: what you want is to lookup a numeric value (exchange rate), based on matching text (currency code) - see the attached example.

CurrencyConverter.fp7.zip

[Maartenjanvdwielen]

Wonderful,

Iam thinking the other way around,

Much Appreciated!