带有公式的If函数中的Google Sheet问题 [英] Google Sheet Issue in If function with array formula

问题描述

Google工作表如果"中存在问题功能如下所述:

Am facing issue in google sheet "if" function as discussed below:

在Google表格的B4单元格中(下面给出了链接)正在使用以下公式，然后通过拖动公式获得正确的结果:

In Cell B4 of the Google Sheets (link is given below) am using below formula and then by draging the formula am getting correct result :

= if(isblank(C4)，B3，C4)

=if(isblank(C4) , B3 , C4 )

但是当我对ARRAYFORMULA使用相同的公式时，会出现错误.在单元格A4中应用了ARRAYFORMULA:

But when I use the same formula with ARRAYFORMULA am getting the error. The ARRAYFORMULA is applied in cell A4:

= ARRAYFORMULA(if(isblank(C4:C)，A3:A，C4:C))

=ARRAYFORMULA(if(isblank(C4:C) , A3:A , C4:C ))

在上述情况下，有关如何使用ARRAYFORMULA修复错误的帮助将不胜感激.

Help on how to fix the error with ARRAYFORMULA in above case would be greatly appreciated.

以下是工作表的链接:

https://docs.google.com/spreadsheets/d/1fB31msHFWDVv9eweb2H0XJ6zDfpKjxEZG9bpXb36_44/edit#gid = 0

推荐答案

限制行数并将此公式应用于需要的第三行在此处 https://infoinspired.com/google-docs/spreadsheet/fill-blank-cells-with-the-values-above/原因是当查找在密钥中发现错误时，它会使数字立即降低.这就是为什么当单元格为空时我们将行除以0的原因.

Limit the number of rows and apply this formula in third row wherever you need This is explaned here https://infoinspired.com/google-docs/spreadsheet/fill-blank-cells-with-the-values-above/ The reason is that when lookup find an error in the key, it takes the number immediatly lower. It's why we divide the row by 0 when the cell is empty.

=ArrayFormula(lookup(row(C3:C),row(C3:C)/if(C3:C<>"",1,0),C3:C))

这篇关于带有公式的If函数中的Google Sheet问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！