英文:
How to call cell value within concatenate function in google sheets?
问题
I have prepared a sheet pic attached
In cell B1, enter a formula
>0
In cell CF2, entered a formula
=IFS(B1<>"" , " AND Col21 "&B1&" " , B1 = "", "")
and the result is AND Col21 >0
In cell CD2, I have entered the formula
=IFS(CONCATENATE( CA2, "1")<>"" , " AND "&CC2&" "&CONCATENATE( CA2, "1")&" " , CONCATENATE( CA2, "1") = "", "")
and the output is AND Col21 B1
But, I want to be desired output as AND Col21 >0
In other words, I need to call the value of the cell B1 instead of the Name B1.
英文:
I have prepared a sheet pic attached
In cell B1, enter a formula
>0
In the cell CF2, entered a formula
=IFS(B1<>"", " AND Col21 "&B1&" " , B1 = "", "")
and the result is AND Col21 >0
In cell CD2, I have entered the formula
=IFS(CONCATENATE( CA2, "1")<>"", " AND "&CC2&" "&CONCATENATE( CA2, "1")&" " , CONCATENATE( CA2, "1") = "", "")
and the output is AND Col21 B1
But, I want to be desired output as AND Col21 >0
In other words, I need to call the value of the cell B1 instead of the Name B1.
答案1
得分: 2
=你可以尝试在公式的CONCATENATE部分内使用[INDIRECT()]函数*
=let(cell_,indirect(CA2&"1"),
ifs(cell_<>"", " AND "&CC2&" "&cell_&" " , cell_="",""))
英文:
<!-- language-all: js -->
You may try n' wrap the CONCATENATE part of the formula within INDIRECT()
=let(cell_,indirect(CA2&"1"),
ifs(cell_<>"", " AND "&CC2&" "&cell_&" " , cell_="",""))
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论