Is it possible arrayformula combined with many if, and, isblank ??

The code below works fine


I have to make ERP in google spreadsheet

I'm tying to combine arrayformula with upper code.

=arrayformula(IF(AND(ISBLANK(F8:F)=TRUE,ISBLANK(H8:H)=FALSE), "Not shipped", IF((AND(ISBLANK(F8:F)=FALSE,ISBLANK(H8:H)=FALSE)),"Shipped","")))

Doesn't work..

I want to put combined arrayformula in G8 cell It's really bother me


1 Answer 1


The functions AND as well as OR do NOT work in arrayformulas.

One should use the multiplication sign * and the addition sign + respectively.

So your formula will be

=ArrayFormula(IF((ISBLANK(F8:F)=TRUE)*(ISBLANK(H8:H)=FALSE), "Not shipped", 
  • Welcome. Please remember that as per site guidelines when an answer addresses your question, accept it and even upvote it so others can benefit as well. Oct 23, 2020 at 2:59
  • it good for me! thank you
    – GM B
    Oct 23, 2020 at 3:45
  • Glad I could help. And thank you for taking the time to accept. Oct 23, 2020 at 7:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.