How do add up a column of Amount with Multiple currencies and then to display the Sum in USD on a real-time exchange rate? Eg:
HK$ 200
GBP 300
USD 1000
MYR 700
I will like to sum the above and display in USD on real time basis. Appreciate your help.
MacBook, macOS 10.15
Hi yamyk1974,
Not in real time. Click in a cell and type = to bring up the Function Browser.
Type currency in the search box.
The CURRENCY function returns data from the previous market day's close.
Read the information on the various options for the price parameter.
Regards,
Ian.
Hi yamyk1974,
Not in real time. Click in a cell and type = to bring up the Function Browser.
Type currency in the search box.
The CURRENCY function returns data from the previous market day's close.
Read the information on the various options for the price parameter.
Regards,
Ian.
Numbers: Adding up Multiple Currencies and Display as USD on real time basis
