wholesale hamsa jewelry Different currency cases in the Excel form conversion formula

By huanggs
wholesale hamsa jewelry There are 6 currencies: CNY USD GBP HKD JPY EUR. The content of the content in the input content is USD1500.00, and A2 is automatically converted into US dollars. Please do not divide the currency and amount in A1 into two cells to solve this problem, because there are problems in the input format.