Need help adding text to a formula

leopardhawk

Well-known Member
Joined
May 31, 2007
Messages
611
Office Version
  1. 2016
Platform
  1. Windows
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.
Code:
=YEAR(NOW())&" OAS Recovery Tax threshold"
This formula is returning $77580.00
Code:
=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!
 

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Try...

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

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

Cheers!
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,170
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top