Microsoft Office Forums - View Single Post - [Solved] Concatenating in an Array formula

Thread: [Solved] Concatenating in an Array formula

View Single Post

Old

02-21-2019, 06:57 AM

Phil H

Phil H is offline

Phil H uses Windows XP

Windows XP Phil H uses Office 2010 64bit

Phil H uses Office 2010 64bit

Office 2010 64bit

Advanced Beginner

The original poster

Join Date: Jun 2010

Posts: 81

Phil H is on a distinguished road

Default

Concatenating in an Array formula

How to concatenate " (24%) " into this array formula?

{="After-Tax Balance " & TEXT(INDEX(AH:AH,MAX(IF(AH5:AH200="",FALSE,ROW(AH5 :AH200)))), "$#,##0")}

Result now is: After-Tax Balance $100
Desired: After-Tax Balance $100 (24%)

Reply With Quote