對于 Y 列，我有以下（非常丑陋的）方程式：
=IF(ISTEXT(Q2),"NO VIDEO DATA",IF(REGEXMATCH(VLOOKUP(I2,DEALS_RNG,COLUMN(DEALS!$G$1)-COLUMN(DEALS!$A$1) 1,FALSE), "Likes"), IF(P2>=(VLOOKUP(I2,DEALS_RNG,COLUMN(DEALS!$F$1)-COLUMN(DEALS!$A$1) 1,FALSE)), IF((R2<> W2),IF(R2,CONCATENATE("DUE: ", CONCATENATE("$",M2)),IF(W2,CONCATENATE("DUE: ", CONCATENATE("$",L2)),)),IF((R2* W2)>0,"COMPLETED",CONCATENATE("DUE: ", CONCATENATE("$",Z2)))),IF(today() >= N2 K2,IF(X2,"PAID: MUST REPOST","NO PAYMENT: MUST REPOST"),IF(today() < N2 K2,CONCATENATE((N2 K2)-today()," days remaining"),))), IF(Q2>=(VLOOKUP(I2,DEALS_RNG,COLUMN(DEALS!$F$1)-COLUMN(DEALS!$A$1) 1,FALSE)), IF((R2<> W2),IF(R2,CONCATENATE("DUE: ", CONCATENATE("$",M2)),IF(W2,CONCATENATE("DUE: ", CONCATENATE("$",L2)),)),IF((R2* W2)>0,"COMPLETED",CONCATENATE("DUE: ", CONCATENATE("$",Z2)))),IF(today() >= N2 K2,IF(X2,"PAID: MUST REPOST","NO PAYMENT: MUST REPOST"),IF(today() < N2 K2,CONCATENATE((N2 K2)-today()," days remaining"),)))))
沒有深入了解這里發生的完整邏輯，基本上就像現在一樣，當我將它向下拖動時它運行正常：
我將 AND() 更改為 * 并將 XOR() 更改為 <> 以及我的單元格從 Q2 到 Q2:Q 等。但是一旦在 ArrayFormula 中，公式不再正常作業并回傳奇怪的數字（也許是記憶體？idk） ：
誰能幫助我了解發生了什么以及如何解決這個問題？
感謝我能得到的任何幫助！
uj5u.com熱心網友回復：
嘗試：
=ARRAYFORMULA(IFERROR(IF(ISTEXT(Q2:Q), "NO VIDEO DATA",
IF(REGEXMATCH(VLOOKUP(I2:I, DEALS_RNG, 7, ), "Likes"),
IF(P2:P>=(VLOOKUP(I2:I, DEALS_RNG, 6, )),
IF(R2:R<>W2:W,
IF(R2:R, "DUE: $"&M2:M,
IF(W2:W, "DUE: $"&L2:L, )),
IF((R2:R*W2:W)>0, "COMPLETED", "DUE: $"&Z2:Z)),
IF(TODAY()>=(N2:N K2:K),
IF(X2:X, "PAID: MUST REPOST", "NO PAYMENT: MUST REPOST"),
IF(TODAY()<(N2:N K2:K), (N2:N K2:K)-TODAY()&" days remaining", ))),
IF(Q2:Q>=VLOOKUP(I2:I, DEALS_RNG, 6, ),
IF(R2:R<>W2:W,
IF(R2:R, "DUE: $"&M2:M,
IF(W2:W, "DUE: $"&L2:L, )),
IF((R2:R*W2:W)>0, "COMPLETED", "DUE: $"&Z2:Z)),
IF(TODAY()>=(N2:N K2:K),
IF(X2:X, "PAID: MUST REPOST", "NO PAYMENT: MUST REPOST"),
IF(TODAY()<(N2:N K2:K), (N2:N K2:K)-TODAY()&" days remaining", )))))))
轉載請註明出處，本文鏈接：https://www.uj5u.com/qukuanlian/468971.html
下一篇：如果資料庫中不存在值，則運行回圈