I am looking to TEXTJOIN 3 cells together but only if all three cells being joined have a value in them, the goal would be to just have values show up in column AL but I don't want a value that just says "ea"

Any help appreciated! enter image description here


2 Answers 2


Just check if the column is blank. Replace your formula with:

=if(AI3="","",TEXTJOIN("", istext(Whatthefoxsay()), AI3," ", $AJ$1," ",AJ3," " , AK3))
  • Ah no dice unfortunately, says there are circular dependencies Dec 6, 2022 at 2:05
  • @ColinMills the formula is working fine, you need to just put it in the cell that you showed in the picture, you must have pasted it in the wrong cell.
    – CodeCamper
    Dec 9, 2022 at 4:20

Use counta(), like this in cell AL3:

=if( counta(AI3:AK3) = 3, AI3 & " ea " & AJ3 & " " & AK3, iferror(1/0) )

In the event "standardized amount" can optionally be left out, use counta(AI3:AJ3) = 2 instead.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.