Q: Currency Conversion in Numbers
I'm pretty new to numbers, so forgive me if this is a dumb question.
I'm trying to convert a dollar amount in one cell to another currency in another cell. Preferrably with live exchange rates. Is there a way to do this?
MacBook Pro, OS X Mavericks (10.9.3)
Posted on Jun 11, 2014 5:26 PM
by Jerrold Green1,Solvedanswer
Add a column for CHF, and in the Header Paste the conversion figure. Let's say your Euros are in Column D; then your CHF calculation, assuming they will be in Column E, would be:
=E$1*D
or
=E$1/D
depending on which way you get the conversion from the website.
In a Footer row, write:
=SUM(D)
in Column D and Copy/Paste to the Footer cell of Column E.
Jerry
Posted on Jun 11, 2014 6:58 PM
