You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Numbers: Adding up Multiple Currencies and Display as USD on real time basis

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

Posted on Jul 12, 2020 2:54 AM

Reply
Question marked as Top-ranking reply

Posted on Jul 12, 2020 6:09 AM

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.

1 reply

Numbers: Adding up Multiple Currencies and Display as USD on real time basis

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.