Converts a Long, Double, String, or equivalent expression to money in the currency of whatever scope it's being evaluated in.
Syntax
to_money(x)
Parameter
X can be a Long, Double, String, or equivalent expression.
If your locale uses a comma to separate decimals, surround any Long, Double, String you enter with quotes. For example, these two formulas are equivalent:
To_money(“1,50”)
- A comma separates the integer from the decimal, so you need to surround the amount with quotesTo_money(1.50)
- A period separates the integer from the decimal, so you don't need to surround the amount with quotes
Examples
to_money(Clicks * 0.02)
orto_money(Clicks * to_money("0,02"))
In this example, an advertiser places a value of 2 cents for each click. So the advertiser creates a formula that multiplies the number of clicks by 2 cents and converts the result to money. By placing this formula in a column on the Campaigns tab, the advertiser can compare the value generated by each campaign.
Both formulas are equivalent. The second formula uses a comma to separate decimals.
if(Cost > to_money(100.50), "coût élevé", "--")
orif(Cost > to_money("100,50"), "coût élevé", "--")
In this example, an advertiser wants to display a notice on the keywords report if the cost of a keyword rises above 100 dollars and 50 cents. So the advertiser creates a formula that converts 100.50 (or "100,50") to money. Then the formula compares the result with the cost of a keyword. If the cost is higher than 100.50, the formula outputs "coût élevé". The advertiser places this formula in a column on the Keywords tab. Then the advertiser uses the column to sort the report and display all expensive keywords at the top of the report.