谷歌表IF和语句不起作用(google sheets IF AND statements not working)
您好我试图在现有的IF语句中执行AND IF语句,但它没有从单元格O:O读取值
这是代码 - 包含的表格的屏幕截图
关于我做错什么的任何想法
=数组式(IF(ROW(G:G)= 1,“状态”,IF(A:A =“”,“”,IF(E:E =“”,“进行中”,IF(E:E < 5000, “已完成”,(如果(AND(E:E> = 5000,O:O = “接受”), “已完成”, “”)))))))
Hi im trying to execute a AND IF statement inside an existing IF statement but its not reading the value from cell O:O
Here is the code - screenshot of the sheet included
Any ideas on what im doing wrong
=Arrayformula(IF(ROW(G:G)=1,"Status",IF(A:A="","",IF(E:E="","In Progress",IF(E:E<5000,"Completed",(if(AND(E:E>=5000,O:O="Accept"),"Completed","")))))))
最满意答案
AND无法在数组中工作。 看看这个(稍加修改)的公式是否适合您?
=Arrayformula(IF(ROW(G:G)=1,"Status",IF(A:A="","",IF(E:E="","In Progress",IF(E:E<5000,"Completed",if( (E:E>=5000)*(O:O="Accept"),"Completed",""))))))AND doesn't work in an array. See if this (slightly amended) formula works for you ?
=Arrayformula(IF(ROW(G:G)=1,"Status",IF(A:A="","",IF(E:E="","In Progress",IF(E:E<5000,"Completed",if( (E:E>=5000)*(O:O="Accept"),"Completed",""))))))更多推荐
发布评论