Formatting Formula

[MrPardal]

Hi Guys,

So i have this formula above and i want the result in Currency, like “0€” not “0”.
Can anyone help me?

IF((Tipo2)=BLANK(),“0”,IF((Tipo2)=“Fatura EU”,“0”,Valor*0.23))

Thanks

[kuovonne]

If all you want to do is tack the € symbol to the end, you can concatenate the symbol to the end
IF((Tipo2)=BLANK(),"0",IF((Tipo2)="Fatura EU","0",Valor*0.23)) & "€"

However, you may loose some formatting of the number (commas, decimal points, etc.) when you tack on the euro symbol. “Pretty printing” of numbers when converting them to strings has been an issue for a while.

By the way, if you want a blank value instead of “0” when {Tipo2} is blank, you can use an empty string "".

IF((Tipo2)=BLANK(),"",IF((Tipo2)="Fatura EU","",Valor*0.23 & "€"))

[MrPardal]

Hi, thanks for the reply,
yes, i know that solution but it loose the formatting and then i cannot use it with another Formula, but tks!

[kuovonne]

Since you want to use the number in another formula, you better off leaving it as the original formula in one field, and having a different formula field for display purposes.

For an extensive example of formatting calculated numbers for display purposes, see @W_Vann_Hall’s Show and Tell post for “Pretty-Print”. While his currency demos use the $ symbol, you could edit his formulas to use the € symbol. (I recommending using a code editor such as Notepad++ for editing his formula–it’s a very complex formula.)

Number and Currency 'Pretty-Print' Routines Show and tell

tl;dr version: A demonstration base offering three approaches to formatting numbers or numerals while providing ‘pretty-print’ formatting (e.g., currency indicators, thousands and decimal separators, and so on). Allows for non-US separators and decimals, as well. The third table supports parentheses for negative values, right-aligned output with a specified number of columns, and more. A while back, in response to this query, I started on what I thought would be no more than a half-hour’s task…