Home

Problem using Textjoin with concatenate

Syl1017
New Contributor

I have a TEXTJOIN formula that concatenates text based on an IF function.  The IF function looks at a range in column A and if the value in cell A1:A5>0, it concatenates text in B1:B5 with a ", " delimiter between each.  It is capturing all the correct text cells, but it is also adding an extra "0, 0," between each text string.  What am I doing wrong?

1 Reply
Resolved.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies