#1
|
|||
|
|||
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%) |
#2
|
||||
|
||||
Post a sample file. thx
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Sorry, Pecoflyer, the file has confidential and personal identifiable information. Maybe I have to dismiss this post?
|
#4
|
|||
|
|||
Is (24%) just something you enter and not the result of another formula? If Yes, try:
="After-Tax Balance " & TEXT(INDEX(AH:AH,MAX(IF(AH5:AH200="",FALSE,ROW(AH5 :AH200)))), "$#,##0")&" (24%)" Array-entering not necessary. (By the way - never use full column references in array formulas, that's really bad practice). |
#5
|
|||
|
|||
xor, Thanks for your help. Yes, this is simply a notation of a tax bracket. Tried it as you suggested, but the only way it would work is as an array formula. Regarding your comment on not using column references, how should the formula be stated?
|
#6
|
|||
|
|||
Yes you are right about array formula.
="After-Tax Balance " & TEXT(INDEX($AH$5:$AH$200,MAX(IF($AH$5:$AH$200="",F ALSE,ROW($AH$5 :$AH$200)))), "$#,##0")&" (24%)" |
#7
|
|||
|
|||
xor, This works too - without array entry. Thanks for the education... R/Phil
|
Tags |
array, concatenate |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Array formula value not available error for one result | emarkona | Excel | 1 | 03-08-2018 03:00 PM |
Array Formula | Macacidic | Excel | 2 | 09-12-2017 08:19 AM |
Excel simplify formula - array of sequential numbers | Wries | Excel Programming | 1 | 05-12-2014 08:32 AM |
Convert String Array to Integer Array from a User Input? | tinfanide | Excel Programming | 4 | 12-26-2012 08:56 PM |
Complex array formula | andrei | Excel | 9 | 02-03-2012 03:40 AM |