Put a symbol after a number using a formula...

[Losguapos1]

Good morning,

So i know there is a way to always put a symbol after number.

I currently have the following formula in a cell: =IFERROR(O15+O23+O31,"") this formula is perfect and works every time but i want the resulting number to have "*" after each number. Is this at all possible.

Thanks in advance

Los

[Andy Pope]

You can append to result, but will turn result to text.

=IFERROR(F8+F10+F12 &"*","")

you could use a custom number format

General\*

[samba_ravi]

=IFERROR((O15+O23+O31)&"**","")
try this

[Losguapos1]

That worked awesome!!!

Thanks
Los