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!

Register Yourself Login