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?

 

[Grayc16]

Formula is:

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

 

[Joe4]

Welcome to the Board!

Try:

[COLOR=#333333]=CONCAT("Users: ", F8, " vs ", F9, " (+ ", TEXT(F10,"0%"), " YOY)")[/COLOR]

 

[Grayc16]

CONCAT formula to make decimal output a pecantage

Sorry, couldn't edit first post.

Is there a formula to make F10 in the formula below output as a percentage and not a decimal?

Also, is there a way to make F10 a + or - based on whether it is an increase or decrease of growth?



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

 

[Aladin Akyurek]

Formula is:

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

Like this for example:

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

 

[Grayc16]

Thank you so much that worked great!!!!! I really appreciate it.

 

[Joe4]

I have merged your two threads together. Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #12 here: Forum Rules).

Regarding this:

Also, is there a way to make F10 a + or - based on whether it is an increase or decrease of growth?

Is there already a negative on F10 if there is a decrease? If so, it should be picked automatically by the current formula.
If not, where can we look to tell if there has been an increase or decrease?

 

[Grayc16]

It's all good. It worked perfectly. Sorry, first timer. Moreover, in the formula F8 vs. F9 comes out in the full million number, is there also a way to automatically abbreviate both.
For example, F8=198076, how can I make it 1.9k? is there a way?

 

[Joe4]

For example, F8=198076, how can I make it 1.9k? is there a way?

Is there a way, sure. Is there a quick and easy formatting solution? Not that I know of.
I would think of using a series of nested IF function that checks the length of each, and that does the appropriate math and abbreviation. Or create a lookup tables that stores those things and uses that.

If you want to do that, please provide the following for all possibilities:
1. Length
2. What to divide by
3. What abbreviation to use

For example, if you wanted to abbreviate 1,500,000 as 1.5 mil, your answers would be:
1. 7
2. 1,000,000
3. mil

 

[Grayc16]

Okay thank you. One last question, instead of adding the k or m for millions, etc, how can I add a comma so, 193,083 instead of 193083.

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?