Does anyone know how to calculate for exchange rate in formulas, as in if i have lods of entries in US$ and would like to convert them to Thai baht. in both the case when exchange rate is fixed and when its not.
if yes, then wats the formula.
Please let me know asap, would be off great help....
thanx
vaibz
The exchange rate is never fixed.
From USD in Thai Bath
Assume USD is in A1
Exchange rate is in B1 (32.310)
C1= A1*B1, Format cells into
_-[$฿-41E]* #,##0.00_-;-[$฿-41E]* #,##0.00_-;_-[$฿-41E]* "-"??_-;_-@_-
Looking for great solutions but hate waiting?
Seach this Forum through Google
www.Google.com (e.g. +multiple +IF site:excelforum.com/excel-general/ )
www.Google.com (e.g. +fill +combobox site:excelforum.com/excel-programming/ )
Ave,
Ricardo
If it's historic, it won't change anymore.The exchange rate is never fixed.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks