问题描述
我需要创建公式的帮助!我希望公式包含#NV错误,而忽略#NV错误。相反,即使存在#NV错误,也应输出一个值。您有什么想法吗?将错误的值插入分配列表时,将出现#NV错误。我怎么能忽略它?
I need help creating a formula! I want the formula if it contains a #NV error, to ignore the #NV error. Instead, a value should be output, even if there is a #NV error. Do you have any idea how this could work? When a wrong value is inserted in to the Assignment list, there is an #NV error. How can I ignore it?
= ARRAY_CONSTRAIN(ARRAYFORMULA(SUMME(WENN(ODER((WENN($ B $ 2 = dontcare,1 ,(Assignment!$ E $ 3:$ E $ 577 = $ B $ 2)))),(WENN($ B $ 3 = dontcare,1,(Assignment!$ E $ 3:$ E $ 577 = $ B $ 3)))), (WENN($ B $ 4 = dontcare,1,(Assignment!$ E $ 3:$ E $ 577 = $ B $ 4))),(WENN($ B $ 5 = dontcare,1,(Assignment!$ E $ 3 :$ E $ 577 = $ B $ 5))))(WENN($ B $ 6 = dontcare,1,(Assignment!$ E $ 3:$ E $ 577 = $ B $ 6))))*(WENN($ B $ 7) = dontcare,1,(分配!$ F $ 3:$ F $ 577 = $ B $ 7)))*(WENN($ B $ 8 = dontcare,1,(分配!$ B $ 3:$ F $ 577 = $ B $ 8)))),(赋值!G $ 3:G $ 577)))),1,1)
推荐答案
将公式包装在 IFERROR
IFERROR(your-formula-here; "value if error here")
这篇关于如何避免/绕过/忽略Google表格中的#N / A #NV错误?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!