currency

1. Syntax:

Value Number  currency(Number amount, String cur1, String cur2)

Description:

Converts currency amount of cur1 to cur2 using real-time data.

Examples:

($b1:$b5) = currency(10, USD, $a)
Before:
AB C
1EUR
2CNY
3DKK
4GBP
5JPY
6
After:
AB C
1EUR7.287
2CNY68.245
3DKK54.273
4GBP6.409
5JPY899.5
6
($a1) = currency($b1, $c1, $d1)