Posts by Lulu29

    Where do I place CONCAT formula to use commas to separate the thousand and million figure involved in F8 and F9? I.E., instead of 24000= 24,000?

    =CONCAT("Users: ", F8, " vs ", F9, " (+", TEXT(F10,"0.0%"), " YOY)")

    For Text I have: TEXT(F9,"#,##0") but where in the formula do I place it?

    Also for the color of F10, can I automatically make it so it changes to green or red depending on increase or decrease?