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 quotes
To_money(1.50)- A period separates the integer from the decimal, so you don't need to surround the amount with quotes
to_money(Clicks * 0.02)or
to_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é", "--")
if(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.