Forum Discussion
Haytham Amairah
Feb 05, 2017Silver Contributor
How to add separator (comma) inside a formula?
How to separate the value of SUM by comma in this case?
- Feb 06, 2017
Haytham, format the SUM as well, like ="Total: " & TEXT(SUM(D3:D12),"#,##0_ ;-#,##0 "). If I understood your question correctly...
Heelllo
May 15, 2019Copper Contributor
I am trying to write a formula where I am using a cell and a rule. Below explains what i am trying to achieve
A1 - $1,000
=A1 &IF(A1<0,"CR",""
The result i get from this is 1000CR. I cannot get it to format to $1,000CR if cell A1 is less than 0. PLEASE HELP
SergeiBaklan
May 15, 2019Diamond Contributor
Heelllo , you may apply custom number format to your cell like
[$$-en-US]#,##0;-[$$-en-US]#,##0"CR";[$$-en-US]#,##0
or, if with formula, use
TEXT(A1,"[$$-en-US]#,##0") & "CR"
with IF