I have an ARRAYFORMULA that combines text with a number.
But if the value in the B column is 0, I want the output cell to be empty like this:
|1||textB 1||textC 2|
What would be the best way to do this?
I have tried adding an if statement before the arrayformula that looked something like this
=IF(B1:B3=0)," ",ARRAYFORMULA(A1:A3&" "&B1:B3)
I assume that this is checking if the entire range equals 0, but I don't know if there is a way to check values per cell in the range.
I did not realize that ARRAYFORMULA would return a vertical list with a vertical range (although I probably should have figured that).