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:
A
B
C
1
EUR
2
CNY
3
DKK
4
GBP
5
JPY
6
After:
A
B
C
1
EUR
7.287
2
CNY
68.245
3
DKK
54.273
4
GBP
6.409
5
JPY
899.5
6
($a1) = currency($b1, $c1, $d1)