Formatting decibels with text

[JTL9161]

I am trying to sum to numbers but need it show either positive or negative (99% of time it will be positive) with text after the result. For example:

I tried ="+"&sum(a1-a2)&" weekly change"

but my answer came out as: +14.6153846153846 weekly change.

I am trying for: +14.6 weekly change.


Thank you,
James

 

[Fluff]

How about

=ROUND(SUM(A1-A2),1)&" weekly change"

 

[scoudny]

Hi James, try
="+"&sum(ROUND(a1-a2),1)&" weekly change"

 

[Fluff]

If you need the + sign for positive number

=LET(s,ROUND(SUM(A1-A2),1),IF(SIGN(s)>0,"+","")&s&" weekly change")

 

[Joe4]

Is that what you want?

=IF(A1<A2,"-","+") & ROUND(A1-A2,1) & " weekly change"

 

[Fluff]

@Joe4 you don't need the - for a negative.

 

[Eric W]

Maybe:

=TEXT(A1-A2,"+#.#;-#.#")&" weekly change"

 

[JTL9161]

Thank you all!

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Joe4]

@Joe4 you don't need the - for a negative.

Ah, yes, you are correct.

And I don't think you need the SUM in your formula either!