在这个嵌套的if语句中有什么中断？
在这个嵌套的if语句中有什么中断？
提问于 2022-06-21 13:45:38
为什么来自中间函数的输出(应该输出“小2、中2和大2”的值)返回N/A？
=IF([@[BED/BATH]] = "0-1", "Studio",
IF(AND([@SQFT] < 700, OR([@[BED/BATH]] = "1-0", [@[BED/BATH]] = "1-1", [@[BED/BATH]] = "1-1.5")), "Small 1",
IF(AND([@SQFT] < 850, OR([@[BED/BATH]] = "1-0", [@[BED/BATH]] = "1-1", [@[BED/BATH]] = "1-1.5")), "Mid 1",
IF(AND([@SQFT] >= 850, OR([@[BED/BATH]] = "1-0", [@[BED/BATH]] = "1-1", [@[BED/BATH]] = "1-1.5")), "Large 1",
IF(AND([@SQFT] < 1050, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2"), [@[BED/BATH]] = "2-2.5"), "Small 2",
IF(AND([@SQFT] < 1200, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2"), [@[BED/BATH]] = "2-2.5"), "Mid 2",
IF(AND([@SQFT] >= 1200, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2"), [@[BED/BATH]] = "2-2.5"), "Large 2",
IF(AND([@SQFT] < 1100, OR([@[BED/BATH]] = "3-2", [@[BED/BATH]] = "3-2.5")), "Small 3",
IF(AND([@SQFT] < 1300, OR([@[BED/BATH]] = "3-2", [@[BED/BATH]] = "3-2.5")), "Mid 3",
IF(AND([@SQFT] > 1300, OR([@[BED/BATH]] = "3-2", [@[BED/BATH]] = "3-2.5")), "Large 3", "N/A"))))))))))回答 1
Stack Overflow用户
回答已采纳
发布于 2022-06-21 14:08:44
你把三个括号放错地方了。
您的小2、中2和大2 IF公式在OR语句之外有[@[BED/BATH]] = "2-2.5"。
IF(AND([@SQFT] < 1050, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2"), [@[BED/BATH]] = "2-2.5"), "Small 2", 应该是
IF(AND([@SQFT] < 1050, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2", [@[BED/BATH]] = "2-2.5")), "Small 2", "2-2"后的括号已移动到"2-2.5"之后。
最后的方案应是：
=IF([@[BED/BATH]] = "0-1", "Studio",
IF(AND([@SQFT] < 700, OR([@[BED/BATH]] = "1-0", [@[BED/BATH]] = "1-1", [@[BED/BATH]] = "1-1.5")), "Small 1",
IF(AND([@SQFT] < 850, OR([@[BED/BATH]] = "1-0", [@[BED/BATH]] = "1-1", [@[BED/BATH]] = "1-1.5")), "Mid 1",
IF(AND([@SQFT] >= 850, OR([@[BED/BATH]] = "1-0", [@[BED/BATH]] = "1-1", [@[BED/BATH]] = "1-1.5")), "Large 1",
IF(AND([@SQFT] < 1050, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2", [@[BED/BATH]] = "2-2.5")), "Small 2",
IF(AND([@SQFT] < 1200, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2", [@[BED/BATH]] = "2-2.5")), "Mid 2",
IF(AND([@SQFT] >= 1200, OR([@[BED/BATH]] = "2-0", [@[BED/BATH]] = "2-1", [@[BED/BATH]] = "2-2", [@[BED/BATH]] = "2-2.5")), "Large 2",
IF(AND([@SQFT] < 1100, OR([@[BED/BATH]] = "3-2", [@[BED/BATH]] = "3-2.5")), "Small 3",
IF(AND([@SQFT] < 1300, OR([@[BED/BATH]] = "3-2", [@[BED/BATH]] = "3-2.5")), "Mid 3",
IF(AND([@SQFT] > 1300, OR([@[BED/BATH]] = "3-2", [@[BED/BATH]] = "3-2.5")), "Large 3", "N/A"))))))))))页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/72701944
复制相关文章
相似问题
腾讯云开发者
