Need help adding text to a formula

[leopardhawk]

These two formulas are in adjacent cells (I98 and J98) and I want to combine them into one formula and add a bit of additional text.

This formula is returning "2019 OAS Recovery Tax threshold" without the quotes.

=YEAR(NOW())&" OAS Recovery Tax threshold"

This formula is returning $77580.00

=SUM(oas_web!B73)

I want to add the word "The" in front of 2019 and the word "is" after the word "threshold". The combined formula would return this result:

"The 2019 OAS Recovery Tax threshold is $77,580.00."

Appreciate any advice.

Cheers!

 

[Domenic]

Try...

="The " &YEAR(NOW())&" OAS Recovery Tax threshold is "&TEXT(SUM(oas_web!B73),"$#,##0.00")&"."

Hope this helps!

 

[leopardhawk]

Fabulous! I don't know why I couldn't figure it out myself, kept getting errors. Thank you so much for your help.

Cheers!

 

[Rick Rothstein]

Try...

="The " &YEAR(NOW())&" OAS Recovery Tax threshold is "&TEXT(SUM(oas_web!B73),"$#,##0.00")&"."

I know you copied what the OP posted, but since the highlighted text is a single cell reference, the surrounding SUM function call in not needed.

 

[leopardhawk]

So true. Thank you Rick.

Cheers!

 

[Domenic]

Oh yes, that's right, I didn't notice, thanks Rick!