CONCAT formula to use commas

  • 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?

  • Re: CONCAT formula to use commas

    Bit of a wild guess without seeing data/expected results, but generally (where do I place it) you'd replace F9 in the top formula with TEXT(F9,"#,##0")

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!