如何根据是否填充其他字段，以多种方式制定单个单元格?

Question

我想在谷歌表格中得到一个电子表格，我很难找到一个符合我需要的公式，所以我希望这里有人能帮助我。

tbody> <<tr>电池5

A列	B列	C列	D列
细胞1	细胞2	细胞3	细胞4
	细胞6	细胞7	细胞8

像这样?B2:

=如果(A2 =",",如果(D2 =","8:00","))

为C2:

=如果(D2 =",",如果(A2 =","16:00","))

您可以将它们设置为数组公式，分别将它们放在B2和C2中，它们将自动拖动到末尾。

= ARRAYFORMULA(如果(A2: =",",如果(D2: D =","8:00",")))

= ARRAYFORMULA(如果(D2: D =",",如果(A2: =","16:00",")))