TEXTJOIN with IF conditions, but not showing correct format?

[Miarie]

Hello,

So I am trying to use the formula to join all of the data from 1 sheet into a cell if there are multiple rows with the same data on.

It work's for the most part, however the date I want to join together are all percentages, and it keeps joining the data not in a percentage format...

Is there anyway to do this at all?

This is the current formula I am trying to work with:
=ArrayFormula(TEXTJOIN(" - ",TRUE,IF('Saving Calculator'!B15:B45=B43,'Saving Calculator'!C15:C45,"")))

The percentages I want to try and join together are in the C column, and the word it is looking for to match with is in the B column

I have a feeling it will have something to do with TEXT function, but no idea where about to incorporate it into the formula :/

 

[Fluff]

Is this for Google Sheets or Excel?

 

[Miarie]

Its for a Google Sheet

Is this for Google Sheets or Excel?

Google Sheet

 

[Joe4]

Its for a Google Sheet

Google Sheet

Then you do not want to post it to the "Excel Questions" forum (while they are similar in a lot of respects, they are NOT exactly the same).

You want to post it to the "General Discussion & Other Applications" forum. Note the description on that one:

I have moved it for you.

 

[Miarie]

Then you do not want to post it to the "Excel Questions" forum (while they are similar in a lot of respects, they are NOT exactly the same).

You want to post it to the "General Discussion & Other Applications" forum. Note the description on that one:

View attachment 55252

I have moved it for you.

ok thank you very much, and apologies, very new to the forum

 

[Joe4]

ok thank you very much, and apologies, very new to the forum

No worries.

Hopefully someone who uses Google Sheets will be able to help.
I know that in Excel, any kind of concatenate does NOT maintain cell formatting, so you need to use the TEXT function in Excel to maintain.

So, in Excel, if you have 5.00% in cell M1, and you wanted to write in another cell "Total is 5.00%, you could do it like this:
="Total is " & TEXT(M1,"0.00%")

I am not sure if you do it the same way in Google Sheets or not (having to use the TEXT function to format the numeric value).

 

[Fluff]

Not sure if this works with sheets, but try

=ArrayFormula(TEXTJOIN(" - ",TRUE,TEXT(IF('Saving Calculator'!B15:B45=B43,'Saving Calculator'!C15:C45,""),"0%")))

 

[Miarie]

Not sure if this works with sheets, but try

=ArrayFormula(TEXTJOIN(" - ",TRUE,TEXT(IF('Saving Calculator'!B15:B45=B43,'Saving Calculator'!C15:C45,""),"0%")))

Yes this worked! thank you sooooooooooooooo much!

 

[Fluff]

Glad we could help & thanks for the feedback.