December 9, 200916 yr 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..... :
December 9, 200916 yr 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
Create an account or sign in to comment