CONCAT Help

[Grayc16]

How do I use the below formula to output a percentage of F10 instead of a decimal?

Also, is there a way to automatically make it + or - depending on an increase or ad decrease of growth?

 

[Joe4]

With the TEXT function, you can apply almost any custom formatting that you do through the Format menu, so to format F9 to show commas, you could use:

TEXT(F9,"#,##0")

Moreover, the YOY% has an original source formatting of turning red for decrease and green for increase. Can the source formatting be applied to the formula?

Formulas can only calculate/return values. They do not pick up formatting.