jeudi 23 juin 2016

google sheets IF AND statements not working

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","")))))))

enter image description here

Aucun commentaire:

Enregistrer un commentaire