谷歌表IF和语句不起作用(google sheets IF AND statements not working)

谷歌表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",""))))))