Hello,
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? Or can I use k or m to abbreviate numbers?
Formula below:
=CONCAT("Users: ", F8, " vs ", F9, " (+", TEXT(F10,"0.0%"), " YOY)")
For to use commas 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?
1) in the original formula where F9 is seen, replace that with TEXT(F9,"#,##0")
2) If you're asking if you can change part of the cell's color so the F10 part only changes color, no, you can't partially color cells with formulas in them.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Hi, thank you. When I tried that, Excel wouldn't take it and messages kept popping up saying There's a problem with this formula.
Often Excel jumps the cursor in the formula to the spot it is guessing the error to exist. You can show us your version of the new formula and we can possibly suggest a tweak.
Hi, this is what I wrote:
=CONCAT("Users: ", F8, " vs ", TEXT(F9,"#,##0") " (+", TEXT(F10,"0.0%"), " YOY)")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks